if else programming

Demonstrates subdividing a probability distribution or taking portions of the distribution using Excel and SIPmath

Change an Output Distribution Range Name in a SIPmath model

Using Excel show how the Exponential and Poisson distributions compare. Discusses their use in Queuing Models. Also demonstrates the use of SIPmath functions.

Describes how to use a Markov Matrix in generating a forecast with confidence intervals. Demonstrates sensitivity of Markov matrix using SIPmath

See how a CSRA model written with the SIPmath tool can provide insight into the cost and schedule uncertainty in a project. Demonstrated model is available by contacting me. See last slide in video.

See how considering as a collection Low Probability High Value projects can look attractive. Get copy of Excel model

Demonstrates how to use the SIPmath Tool icon "Chance of Whatever". What is the probability that the distribution value is greater than or equal to some value, or equal to some value.

Describes the Metalog distribution in SIPmath that creates a continuous distribution with percentiles 10%, 50% and 90%. Lower and upper bounds can also be set. Video works through an Excel example showing different formats for defining the metalog distribution. .

Demonstrate how to do Probabilistic Sensitivity Analysis using SIPmath and generate Cumulative Distribution Graphs of the results.

Create a basic Tornado Chart in Excel 2016. Useful in showing sensitivities either deterministic or probabilistic. See my other video on Probabilistic Tornados.

Discusses why cost and schedule risk assessments are important citing example. Reviews road blocks to risk analysis. Demonstrates an Excel model written with SIPmath methodology. Shows how the model can be used to investigate mitigations to cost and schedule risk.

Sample and Resample a list (alpha numeric) using Excel and SIPmath.

Works through a reliability analysis using SIPmath to calculate the NPV cost and propose a budget for maintaining the equipment.

Conduct sensitivity analysis of a SIPmath model using Multiple Experiments. Preserve the original model and the sensitivity in the same model.

Describe how to use simulation to evaluate the Let's Make a Deal Paradox. Look at different decision policies using SIPmath simulation.

Evaluate Complex VOI trees - 4 reality and indicator nodes with a 5 branch decision node. Solution uses SIPmath to provide a transparent optimal decision policy.

Presentation given at INFORMS 2017 General Conference - Optimize pipeline maintenance decision policy using SIPmath model and Solver. Test sensitivity of perceived inputs.

Value of Information (VOI) is often evaluated using decision trees. Using SIPmath we can calculate the value of information and also determine the Distribution of the Value of Information. Video takes a case example and walks through the example and analysis. Excel file is available at: https://1drv.ms/x/s!AgtEj5D79IYqgb4iQ...

Review the SIPmath reliability model. Discuss how the Exponential and Weibull distributions compare and how the Triangular and Poisson distributions compare.

Revise the reliability model to use the Weibull and Poisson distributions. Generate a new graphic to propose a cumulative budget for the repair costs.