August 9, 2007 | Issue 207 | www.crystalball.com
If you cannot read this newsletter, you can view it online at
http://www.crystalball.com/newsletters/newsletter207.html



 IN THIS ISSUE


What’s New
- End Of Life For Crystal Ball® 5.x
- WCBF Summit

Crystal Ball Resources
- Seminar: Waterflood Projects
- Textbook: Treasure Chest of Six
        Sigma

- Case Study: Malpractice Lawsuit
- White Paper: Cash Flow
- Risk Tip: The Discrete Uniform         Distribution (Tip 1 of 5)


Conference Roundup
- October 2007

Microsoft® Excel® & The Web
- ExcelTip.com
- Louisepryor.com

Crystal Ball Calendar

CBUG Discussions

Newsletter Subscription Information

 
 WHAT'S NEW


End Of Life For Crystal Ball 2000.5 (5.5) and Earlier Versions

CB 2000Effective October 31, 2007, Crystal Ball Global Business Unit will discontinue the sale of software licenses, maintenance and upgrades for Crystal Ball 2000.5 (5.5) and any earlier versions of the software. We will continue to provide support for the duration of existing support agreements.

> We recommend you upgrade to Crystal Ball 7 (you will need a new license code to do this).  Click here to upgrade Crystal Ball today.

> Contact our services group if you need help converting models to Crystal Ball 7 or for any of other consulting needs.

> Click here if you require help or further information.


WCBF 2nd Annual Global Six Sigma Summit & Industry Awards

WCBF Global Summit 2007

WCBF’s 2nd Annual Global Six Sigma Summit & Awards
October 23-26, 2007
Rio All-Suite Hotel & Casino, Las Vegas

This event is forecasted to have 360+ attendees and includes the Six Sigma CEO Benchmarking Forum. The featured headliner is Jim Collins, author of the top business bestseller, Good to Great.

Visit the Summit Web site for the full program (15% discount when you quote the following discount code: 5081CB15)


 

ISSSP Leadership Conference: Mexico

ISSSPCrystal Ball software is pleased to be presenting a workshop at the ISSSP Leadership Conference Mexico, held September 13-14, 2007 in San Pedro Garza, Nuevo León, Mexico. This is a bilingual event with Spanish-English and English-Spanish translation.

One of our Partners, Antonio Andres Caminos Moreno, will present "Using Simulation and Optimization to Improve Your DFSS Projects" on the morning of the first day of the conference.

> Learn more about this unique event

 
   
 CRYSTAL BALL RESOURCES

Web Seminars
RECORDED WEB SEMINAR:

Using Crystal Ball to Analyze Waterflood Projects

David F. Yard, project engineer and international consultant, will demonstrate the effectiveness of using Crystal Ball with a simple “quick look” model to simulate hydrocarbon recoveries from a waterflood project.  He will also demonstrate the use of Crystal Ball to identify uncertainties associated with any given project and how to use these uncertainties as a way to minimize project risk.  Finally, Mr. Yard couples the model with other proprietary models to forecast the economic returns of the waterflood project.

> View this recorded Web seminar


NEW TEXTBOOK:
Hambleton bookTreasure Chest of Six Sigma Growth Methods, Tools, and Best Practices
By Lynne Hambleton
Published by Prentice Hall PTR, Copyright 2007
Hardbound, 995 pages
ISBN: 0132300214

This reference is the first comprehensive how-to collection of Six Sigma tools, methodologies, and best practices. Leading implementer Lynne Hambleton covers the entire Six Sigma toolset, including more than 70 different tools—ranging from rigorous statistical and quantitative tools, to “softer” techniques. The toolset is organized in an easy-to-use, alphabetical encyclopedia and helps professionals quickly select the right tool, at the right time for every business challenge.

Crystal Ball is included in the Monte Carlo simulation section of the book and in a Portfolio Selection article in the online PDF of related articles. Crystal Ball software is not packaged with this textbook.

> Learn more about this textbook
> Order this textbook from Amazon.com

Risk Resources

SUCCESS STORY:
Monte Carlo Simulation in a Malpractice Lawsuit

Calculation of settlements in malpractice lawsuits is often very difficult. One factor that figures predominantly in a settlement is the cost of care until the person reaches the estimated end of their natural life. There are multiple ways of calculating life expectancy, and these differences can result in million-dollar changes in settlements.

GavelDr. Alastair Muir created a Crystal Ball software simulation model to predict the life table for the plaintiff. Various sources of error-- the reliability of the assessment of the patient--were taken into account and quantified in the model. After Dr. Muir used Crystal Ball to run thousands of Monte Carlo simulations, he was able to calculate the 95% confidence interval for life expectancy for the plaintiff.

The Crystal Ball simulation model provided an unbiased, objective estimate that was judged fair by all parties

> Read the entire success story


Risk Resources

WHITE PAPER:
CASH FLOW AT RISK – ELECTRONIC CHIP PRODUCTION
Alan E Gorlick, University of Phoenix
Source: 2007 Crystal Ball User Conference

Profitable volume production of electronic circuitry runs the gauntlet of unique technical and marketplace hurdles, all of
which involve risk and cost. Many design firms choose to manage the process in house, because they believe the costs are deterministic and within budget. In fact, many of those costs require stochastic models. Single point analysis fails to value:

  1. Cash flow at risk over a range of scenarios

  2. Covariance of cash flows of each new project with existing projects (lack of portfolio effect)

  3. Opportunity costs of bearing risk for which they don’t have a comparative advantage

  4. Costs imposed by the capital markets for bearing risks they should hedge

Crystal Ball software, in concert with experience driven models, quantifies project and total risk, thereby enabling the user to evaluate various hedging strategies.

> Read the entire white paper


resourcesRISK TIP:
How to Use the Custom Distribution in Crystal Ball – The Discrete Uniform Distribution (Tip #1 of 5)

Introduction

The Custom distribution in Crystal Ball is arguably the most versatile, but also one of the most difficult distributions to correctly use within Crystal Ball. In fact, using the Custom distribution, a Crystal Ball software user can construct five different kinds of distributions (see Table below).

Risk Analysis Tip

Distribution

Name used in Crystal Ball User Manual

Tip 1

Discrete Uniform distribution*

"Unweighted values"

Tip 2

Discrete distribution

"Weighted values"

Tip 3

General distribution

"Sloping continuous ranges"

Tip 4

Histogram distribution

"Continuous ranges"

Tip 5

Cumulative Ascending distribution

"Sloping continuous cumulative ranges"

CRYSTAL BALL CALENDAR


TRAINING SCHEDULE

Intro and Advanced Crystal Ball

USA and CANADA

St. Louis, MO: Aug. 14-15
Washington DC: Aug. 14-15
Raleigh, NC: Aug. 21-22
Denver, CO: Aug. 21-22
San Francisco, CA: Aug. 21-22
Austin, TX: Aug. 28-29
Kansas City, KS: Aug. 28-29
Chicago, IL: Aug. 28-29
Rochester, NY: Sep. 5-6
Philadelphia, PA: Sep. 11-12
Minneapolis, MN: Sep. 11-12
Phoenix, AZ: Sep. 11-12
San Diego, CA: Sep. 18-19
Denver, CO: Sep. 18-19
Cincinnati, OH: Sep. 18-19
New York City, NY: Sep. 18-19
Seattle, WA: Sep. 25-26
Washington DC: Sep. 25-26
Edmonton, AB: Oct. 2-3
King of Prussia, PA: Oct. 2-3
Houston, TX: Oct. 2-3
Portland, ME: Oct 9-10
Peoria, IL: Oct.
9-10
Los Angeles, CA: Oct. 9-10
Charleston, WV: Oct. 16-17
Minneapolis, MN: Oct. 16-17
Washington, DC: Oct. 23-24
Cleveland, OH: Oct. 23-24
Orlando, FL: Oct. 30-31
Seattle, WA: Oct. 30-31


EUROPE


London, England: Sep. 4-5
Frankfurt, Germany: Sep. 18-20
Paris, France: Oct. 3-4

LATIN AMERICA

Visit the Web site for updates

ASIA / AUSTRALIA

Visit the Web site for updates

Advanced Crystal Ball for Oil & Gas

Oklahoma City, OK: Aug. 14-15
Houston, TX: Sep. 5-6
Aberdeen, Scotland: Sep. 12-13

Crystal Ball Applications for Six Sigma

Washington DC: Aug. 16
Chicago, IL: Aug. 30
San Diego, CA: Sep. 20
Jacksonville, FL: Sep. 27

Minneapolis, MN: Oct. 18
Washington, DC: Oct. 25

Introduction to Real Options

Denver, CO: Aug. 23
London, England: Sep. 6
New York City, NY: Sep. 20

Frankfurt, Germany: Sep. 20
Seattle, WA: Nov. 1

Spreadsheet Modeling Techniques for Business: Best Practices

Toronto, Canada: Aug. 23
Washington DC: Sep. 27
Paris, France: Oct 5

Suggest a training
date or location

 

 
APPEARANCES


COM 2007- 46th Conference of Metallurgists hosting Cu2007 the 6th Copper/Cobre Conference
August 27-28
Toronto, Canada

ISSSP Leadership Conference
September 13-14
Monterrey, Mexico

IQPC Lean Six Sigma Summit West
September 18-21, 2007
Las Vegas, NV

2nd Annual Global Six Sigma Summit & Industry Awards
October 23-26
Las Vegas, NV

 

YOUR FEEDBACK

If you have questions, comments, or reader feedback, please send them to us at newsletter@crystalball.com
 
SUBSCRIPTION INFO

Tomorrow's Forecast is an online production of Oracle. Newsletters are e-mailed to subscribers near the end of the first and third weeks of the month.

This e-mail newsletter is sent only to those individuals who either:

(1) Subscribed at our Web site, a training course, or a tradeshow, or

(2) Downloaded software from our Web site and requested more Crystal Ball software news.

To Subscribe
Subscriptions to Tomorrow's Forecast are FREE. Click here to subscribe.

To Unsubscribe
To unsubscribe, simply reply to the newsletter with the word 'UNSUBSCRIBE' as the subject of the e-mail. PLEASE leave the body of the message as you received it.

If the e-mail address from which you are replying is different than the one to which this e-mail was sent, please include your original e-mail address.

AOL subscribers: Please state your name in the body of the message.

You can also visit our Web site and follow the unsubscribe directions.


 


* The Discrete Uniform distribution as defined in this tip is a discrete probability distribution in which each of the potential values has the same probability. The Discrete Uniform distribution in Crystal Ball is a special case of this, where the discrete values in the distribution also all have the same probability but can only be integers (also known as a Discrete Uniform Integer distribution).

Each of these five distributions has a different use and application. The way that the Custom distribution “knows” which of the above five to make for you totally depends on the format of your input data ("date entry rules").

The goal of this Risk Tip series is to inform you of the five different distributions that you can construct using the Custom distribution and their various uses. The five Risk Tips will also provide detailed instructions on how to format your data to construct the five different distributions with the Custom Distribution.

> View the full Risk Tip (#1 of 5)

Share a comment, risk analysis tip or a new CB Tip with your fellow Crystal Ball users! Send your contribution to newsletter@crystalball.com.

> Previously published tips and techniques

 


back to top


 
  CONFERENCE ROUNDUP


Our roundup is a list of risk-related events that we publish in the first newsletter of each month. We highlight the events of the next month to give you enough lead time to register for any that interest you.

October 2007

The IASTED Asian Conference on Modelling and Simulation (AsiaMS 2007)
The International Association of Science and Technology for Development (IASTED)
October 8-10, Beijing, China
Beijing Xijiao Hotel
http://www.iasted.org/conferences/home-571.html

ASHRM Annual Conference & Exhibition
American Society for Healthcare Risk Management (ASHRM)
October 10-13, Chicago, IL
Hyatt Regency
http://www.ashrm.org/ashrm/annual2007/

RMA Annual Risk Management Conference
The Risk Management Association (RMA)
October 21-23, New Orleans, LA
Sheraton New Orleans Hotel
http://www.rmahq.org/RMA/default.htm

PRIMA Institute
Public Risk Management Association (PRIMA)
October 22-26, Dallas, TX
Hilton DFW Lakes
http://www.primacentral.org/content.cfm?sectionid=108&EventID=39

WCBF’s 2nd Annual Global Six Sigma Summit & Awards We're there
October 23-26, Las Vegas, NV
Rio All-Suite Hotel & Casino
http://www.gsssa.com
Full program now available to download! 15% discount when you quote the following discount code: 5081CB15

The Huntsville Simulation Conference 2007
October 30 - November 1, Huntsville, AL
The Huntsville Marriott Hotel
http://www.scs.org/confernc/hsc/hsc07/hsc07.htm

3rd Annual European Lean, Six Sigma & Process Improvement Summit We're there
Six Sigma IQ
October 30-31, Amsterdam, The Netherlands
Hotel Okura
http://www.iqpc.co.uk/cgi-bin/templates/singlecell.html?topic=241&event=13624

> Visit our Web site for the entire list of events (or to suggest an event for us to include)



back to top


 MICROSOFT EXCEL & THE WEB


ExcelTip.Com
http://www.exceltip.com/

Founded in March 2003 by Joseph Rubin, ExcelTip.com has become the leading source of Microsoft Excel tips, tricks and information on the web. With over 8,000,000 hits per month, countless number of Excel users have benefited from the vast amount of information available on the site.

Louise Pryor
http://www.louisepryor.com

Louise Pryor, Software Risk Consultant, has developed this site for those that rely on spreadsheet use. The site is designed to make sure a spreadsheet is working correctly. There are many tips and techniques located on this site to help make sure a spreadsheet is done correctly and contains no errors. It's a great resource for the Crystal Ball modeler. Check it out!



back to top


 CBUG DISCUSSIONS


The Crystal Ball User Group (CBUG) is a Yahoo!® online forum where Crystal Ball users can discuss issues and methods related to Crystal Ball software.

Latest topics:

  • Creating custom distribution/assumption
  • CB Behind the Scenes
  • Monitoring a variable with more than one value per iteration

> Click here to visit CBUG and register to become a member

PLEASE NOTE: You have several message delivery options when you join, including whether or not to receive single or digest e-mails. You can also opt not to receive any e-mail and simply log onto the Web site every so often to view discussion.



back to top


Copyright (c) 2007, Oracle and/or its affiliates. All rights reserved.
Oracle, JD Edwards, PeopleSoft, Hyperion and Siebel are registered trademarks of Oracle Corporation and/or its affiliates.
Microsoft and Excel are registered trademarks of Microsoft Corporation in the U.S. and other countries.
Yahoo! is a registered trademark of Yahoo! Inc.