Understanding Triple-D Bridges modeled as Depreciating Assets Field - - PDF document

1/6/2010 1

Keystone Bridge Management System Overview

• Used to create over 400 bridge

inspection reports in seven Ontario municipalities over three years.

• Accepted and preferred by all

municipalities that have retained Keystone Bridge Management.

• Inspired by over 20 years of bridge

management experience.

• Result of over 1,000 hours of MS Access

development work.

• Designed to be easily customizable to any

bridge, bridge type, or client.

• Triple-D approach is easily

understandable and transparent in its functionality.

• Extensive use of context sensitive and

smart-choice drop-down menus.

Understanding Triple-D

• Bridges modeled as Depreciating Assets
• Field inspection captures Defects & Damage
• A Defect is any undesirable change to a bridge

component that is not attributable to normal aging, wear & tear, and does not affect strength

• r serviceability. Concrete scaling is a common

example of a Defect.

• Damage is anything that results in distortion

section loss, or reduced serviceability of a bridge component, ie. spalling, severe corrosion.

1/6/2010 2

Depreciation Curves for a Bridge Component with an 80 Year Life

0% 20% 40% 60% 80% 100% 120% 10 20 30 40 50 60 70 80 90

Percent

Time (years)

Bridge Component Depreciation Curves

Eliptical Parabolic Straight Line Tax 5% 0% 20% 40% 60% 80% 100% 120% 20 40 60 80 100 120

Time (years) Depreciation of Bridge with Multiple Components

Depreciation

Example of Parabolic Depreciation of Bridge with 6 Components

Component Life Relative Value Deck 40 0.3 Joints 20 0.05 Bearings 50 0.05 Superstructure 80 0.25 Substructure 100 0.25 Railings 30 0.1 1.00

1/6/2010 3

Example Calculation of Depreciated Value of Rehabilitated Bridge

Affect of Defects & Damage

• The Depreciated value of a Component is

further written down by Damage. Any component that is 20% Damaged is deemed to be fully Depreciated.

• 10% Defects is considered equal to 1%
• Damage. A new component that has 100%

Defects would have its Depreciated Value decline to 50%.

1/6/2010 4

KBMS Depreciation Reporting KBMS Development

• KBMS is a MS Access Application
• Sophisticated Relational Database
• Extensive Visual Basic Background Coding
• Utilizes Smart-Choice Drop-Down Menus
• Designed to be Highly Customizable
• User with MS Access capabilities can extend

capabilities

• Can work on a single-user or network basis

1/6/2010 5

R

KBMS Database Relationships KBMS Database Queries

1/6/2010 6

KBMS Database Visual Basic Coding KBMS Database Form Designs

1/6/2010 7

KBMS Database User Appendable/Customizable Tables General Arrangement Picture Context Sensitive Drop-Down Lists Easy Form Navigation Mouse Scroll to Component

1/6/2010 8

Compact Form Lay-Out Up to 6 Components per Page Colour Highlighting at Pre-Set Thresholds Your Logo Here General Arrangement Photo on Every Report 11 Drop-Down Menus All Input Fields are Self Checking Smart Input Saves Later Keystrokes

1/6/2010 9

Unlimited Image Handling Mandatory Image Captioning Auto-Loading

• f Next Image

Prompts for Mandatory General Arrangement Image Image Viewing is made Easy & Convenient Scroll through every Image or

• nly General Arrangement

Images Enlarge Image by Pressing Button

1/6/2010 10

Add Bridge Components by simply Checking Box Geometric Information is easily added Specific Bridge Components are chosen from a Context Sensitive Drop-Down Menu

1/6/2010 11

Installing KBMS

• System Requirements

– MS Access 2007 – Windows XP or higher – High resolution monitor (1920 x 1200 pixels)

• Other Considerations

– Digital Camera with numerically sequenced image files – PDF Writer

Create Folder “KBMS” in C:\ Copy Folder “Brookton Images & File “Brookton.mde” into “KBMS” Folder Installing Sample KBMS Software

1/6/2010 12

Double Click on “Brookton” Icon and message below will appear: Click on “Open” button Option: You can avoid the above pop-up screen by creating a “trusted location” on your

• computer. For example make

C:\KBMS a trusted folder. The following menu gives you access to all of the key features of KBMS

1/6/2010 13

To view, edit or append database tables hold the “Shift” button while opening the “Brookton.mde” file. ***Note: The database functionality depends on properly considered changes to these tables.***

Purchasing Considerations

• Stand-Alone or Network

Configuration

• Training Requirements
• Degree of

Customization

• Exclusive or non-

Exclusive rights

• Level of support
• Response Time for

Support

• Additional Forms
• Additional Reports
• Additional Queries
• Single-Year license or

Multi-Year license

• Upgrades