Presenting the IDEAL Estimating System Integrated Data Evaluation

1
Presenting the IDEAL Estimating
System(Integrated Data Evaluation Analysis
Library)
A New Paradigm for Cost Estimating, Modeling, and
Data Sharing
Presented to DOE ACE Team Conference May 9, 2001
Programming by Prime Time Contact Richard F
Seel 985 Old Eagle School Rd Suite 513 Wayne PA
19087 610-964-8200 dick_at_primetime.com
Cost Engineering by Team Analysis,
Inc. Contact William G Hombach 200 South 20th St
Suite B Purcellville, VA 20132 540-338-0601 wghomb
ach_at_teamanalysis.com
2
Central Library (i.e., ASTM)
Cost Models, Estimates, Data can be Run by Anyone
with Internet/Intranet Access ?AT NO CHARGE NO
SOFTWARE TO BUY

• Share Project Cost Model
• Share Cost Estimating Relationships/Cost
  Assemblies
• Share Project Cost Estimates
• Library Contributor Dictates
• Accessibility from General Public to Company
  Personnel
• Acquisition Charge if Any

3
Develop an Electronic Standard using eXtensible
Markup Language (XML)

• Cross Platform (Windows, NT, Unix)
• Cross Application (NORM, RTET, IDEAL, and
  Potentially many more)
• Cross Network (Internet, Intranet, LAN)
• Models Data as Objects
• Dynamically Build Hierarchical Relationships

4
IDEAL Estimating System(Integrated Data
Evaluation Analysis Library)

• Use IDEAL ?Create/Edit Compliant XML for Cost
  Models, Estimates, and Other Data
• IDEAL is Truly Object Oriented
• Module Tree View of Objects as Technology
  Elements
• Phase Tree View of Objects as Schedule Elements
• IDEAL Maps View of Objects Tied to Tree
• Uses Class System to Objectify the Data (i.e.,
  ECES)
• Uses Intelligent Light Client Server Technology
• Available Over Internet Runs Without Browser on
  Users Machine
• Is not Installed on Users Machine
• No Versionitis? Always Latest Version

5
IDEAL Estimating System

• Allows user to create Cost Estimating
  Relationships (CER)
• Link CER to system level parameters (L_FT, W_FT,
  CY)
• Shadow CERs from other (Horizontal Relationships)
• Can use data or CERs from a Library of Components
• Can Create new CERs through Portal to Spreadsheet
• Develop Point Estimates representing CER
• Develop Regression Analyses
• Enter CERs, System of CERs, or Estimates into an
  IDEAL Component Library

6
Provide Cost Model Library for each Agency

• Share Project Cost Models
• Share Cost Estimating Relationships/Cost
  Assemblies
• Share Project Cost Estimates
• Make Data Library Accessible According to
  Security Clearance from General Public to Company
  Personnel

7
IDEAL Estimating System
IDEAL Modules or Plug-ins

• Project Management
• Develop Gantt Charts using SERs ? Interface with
  Project Management Software (i.e., Primavera)
• Time Value (Current Year , Then Year , Net
  Present Value etc.)
• Cost Risk
• Monte Carlo Simulation
• Range Estimating
• Active Mapping
• Desktop Integration
• Build Wizards and Pre/Post Processors
• SQL Import/Export ? Interface w/ Legacy Systems
• Object Linking Embedding

8
Use of Spreadsheets

• Advantages
• Free Form
• Can Develop Equation and Document on the Fly
• Can Include Complex Relationships between Cost
  Elements
• Not Constrained by Parent/ Child Relationships
• Intuitive the Creator - no Programming Skills
  Needed

• Disadvantages
• No Apparent Conventions
• Can be Difficult for user to Understand
• Easily Broken by User
• Spreadsheets become Volatile when too Large
• Operates out of Memory not Storage
• Security and User Interface is a Problem

9
Use of Database

• Advantages
• Can Handle Large and Complex Data Sets
• Can Use Standardized Unit Price Databases
• More Robust Less Likely to Break
• Provides a more Intuitive User Interface
• Better Security

• Disadvantages
• Referential Integrity
• Requires Error Checking and Maintenance
• Requires Programming
• Locked into a Parent/ Child Relationships
• Vertical Relationships
• Difficult to Visualize Relationships within Data

10
IDEAL Estimating System
You Can Have Your Spreadsheet Database
Too!! With the advantages of both and
disadvantages of neither

• Uses Spreadsheet Interface
• Develop/Maintain Cost Models in Comprehensive
  Development Environment and/or Supporting
  Spreadsheets
• (Develop CERs in Spreadsheet Templates Inside
  IDEAL or External for Conversion)
• Export to Spreadsheets for Documentation and
  Other Uses
• IDEAL is Object Oriented
• Module Tree View of Objects as Technology
  Elements
• Phase Tree View of Objects as Schedule Elements
• IDEAL Maps View of Objects Tied to Tree

11
IDEAL Estimating System(Integrated Data
Evaluation Analysis Library)
Development Environment

• Allows user to input information for a new CER
• Link CER to system level parameters (L_FT, W_FT,
  CY)
• Shadow CERs from other (Horizontal Relationships)
• Can use data or CERs from a Library of Components
• Can Create new CERs through Portal to Spreadsheet
• Develop Point Estimates representing CER
• Develop Regression Analyses
• Enter CERs, System of CERs, or Estimates into an
  IDEAL Component Library

12
Project Cost ModelsExample - Bioslurping

• Installation
• Project Management
• Bioslurping System
• Media Filtration
• Air Stripping
• GAC
• Thermal Oxidation
• Off-Site Disposal
• Remedial Design
• Remedial Design

• Operations
• Project Management
• Bioslurping System
• Media Filtration
• Air Stripping
• GAC
• Thermal Oxidation
• Discharge to POTW
• Process SA

13
IDEAL Estimating System
14
IDEAL Estimating System
Initial Screen ? Required Parameters
15
IDEAL Estimating System
Next Screen ? Secondary Parameters
16
IDEAL Estimating System
Default Tree View ? by Technology
17
IDEAL Estimating System
Project Phase Tree View
18
IDEAL Estimating System(Integrated Data
Evaluation Analysis Library)
2 Windows Opened and Tiled Windows ? Library,
Model, Estimate, or Data Can Copy From One to
Another New Branch in Tree Looks to Parent for
Data
19
IDEAL Estimating System
Technology Tree View ? Ex Situ Groundwater
Expanded Showing All Technologies (Enabled
Disabled)
Right Click Menu
20
IDEAL Estimating System
Running Air Stripping ? Secondary Parameters
Screen
21
Forms Dialogue used to Edit Parameters in
Worksheet
22
IDEAL Estimating System(Integrated Data
Evaluation Analysis Library)
Dynamic Scheduling