Formatting Diagrams in Diagram Master

This video demonstrates formatting diagrams in Diagram Master. Diagram Master is an Excel add-in for creating node based diagrams. For more information, visit the Diagram Master product page. Topics Covered Formatting all nodes at the same time. Formatting subsets of nodes. Formatting all connectors at the same time. Formatting subsets of connectors. Selecting/Deselecting individual nodes …

Project Critical Path Analysis Using Simulation

Project critical path analysis can be performed using Monte Carlo simulation as a way to determine project completion time probabilities.  In this article, we will create a network diagram in Excel and a table to perform necessary logic operations. We will assume that each task follows the PERT distribution (also called Beta-PERT).  Using past experience, …

Monte Carlo Tolerance Analysis

Monte Carlo simulation can be used for tolerance analysis (Monte Carlo tolerance analysis) to determine the rejection rate of assemblies.  In this application we will look at an example assembly where parts A and B must fit inside part C with a clearance fit.  For performance reasons we want to minimize the total clearance so …

Input Variable Correlation in Monte Carlo Simulation

When conducting a Monte Carlo simulation, correlation among input variables is an important factor to consider.  If input random variables are treated as independent, when they are actually correlated, risk can be under or over estimated. Let’s think about how this occurs, when two input variables have positive correlation, the value for each should be …

Creating a Structured Diagram with Diagram Master

This video provides and overview of a structured diagram using Diagram Master. Diagram Master is an Excel add-in for creating node based diagrams. For more information visit the Diagram Master product page. Topics Covered Create a diagram worksheet. Add nodes. Edit nodes. Change diagram settings. Introduction This video demonstrates how to create a structured diagram …

Diagram Master Overview

This video is an overview of the features of Diagram Master. Diagram Master is an Excel add-in for creating a node based Excel diagram. For more information, visit the Diagram Master product page. Topics Covered The structured diagram group on the ribbon is explained for the creation of structured node diagrams such as tree diagrams, …

Creating a Mind Map with Diagram Master

This video demonstrates how to create a mind map in Excel using Diagram Master. Diagram Master is an Excel add-in for creating node based diagrams. For more information, visit the Diagram Master product page. Introduction This video demonstrates how to create a mind map using Diagram Master. Create a Diagram Worksheet First we start by …

Analyzing Simulation Data with Simulation Master

This video demonstrates the simulation data analysis and reporting features of Simulation Master.  Simulation Master is an Excel add-in for Monte Carlo simulation.  For more information, please visit the Simulation Master product page. Topics Covered Probability analysis of an existing simulation data set. Create a summary report of an existing simulation data set. Create a …

Basic Monte Carlo Simulation Using Simulation Master

This video demonstrates a basic Monte Carlo simulation using Simulation Master. Simulation Master is an Excel add-in for Monte Carlo simulation. For more information, please visit the Simulation Master product page. Basic Monte Carlo Simulation Topics Random variable function set-up in Excel model Using the Simulation Master “RV” worksheet functions to create random variables used …

Using Mind Maps for Project Planning

Mind maps are a useful way to organize information and to gather input from a group.  A mind map is simple to construct and is really an organized way of collecting your (or your group’s) thoughts.  By visually mapping out a problem, project tasks or set of ideas, you are engaging a different part of …