if else programming

Change an Output Distribution Range Name in a SIPmath model

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.

Given P10-P50-P90 points from a distribution, how can we sample from that distribution. Create presentation quality cumulative distribution graphs (CDFs) of the distribution using SIPMath

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. .

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.

Instruction on how to download and install in Excel the SIPmath tool bar of July 2017..

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

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...

Part 2 - Taking a Multiple Experiment SIPmath Model and converting it to a typical SIPmath model with multiple outputs. Please see a subsequent video that describes a simpler process. https://www.youtube.com/watch?v=OtGcq...

Extends the first video on converting Crystal Ball to SIPmath by adding a better Cumulative Distribution graphic using the Percentile command. Excel available at : https://1drv.ms/x/s!AgtEj5D79IYqgb4gA...

Builds on Parts 1 & 2 to compare alternatives using a single cumulative distribution chart. Establishes a reference case for comparison to other alternatives assessed in the model. Excel is available at : https://1drv.ms/x/s!AgtEj5D79IYqgb4gA...

This is the epilogue to 2 previous videos that evaluated the optimum price for concert tickets when we consider uncertainty in demand and cost using SIPmath. The epilogue updates the model, discusses why the triangular distribution was used and then shows how survey results can be utilized to determine a probabilistic demand profile for the tickets. The objective of the series is to demonstrate good Decision Quality practices. Excel file available at : https://1drv.ms/x/s!AgtEj5D79IYqgb4fM...

Optimize a portfolio of ETFs by maximizing the P10 outcome. Compare outcomes using cumulative distribution graphs. Excel model used in the video is available at: https://1drv.ms/x/s!AgtEj5D79IYqgctBj... or contact me at brian@theputts.com

Describes how to generate various distributions with SIPmath and compare them as cumulative distribution curves. All that is required is Excel and the SIPmath tool bar which is a free download from the Non-profit probabilitymanagement.org.

Describes a 10 period model that considered probabilistic demand to optimize the order quantity. Analysis is shown and the impact of using an order quantity that is not optimal. A copy of the model is available at https://1drv.ms/x/s!AgtEj5D79IYqgd0yX... or contact me at brian@theputts.com

Value of Information Distribution is useful in telling the VOI story. This case study discusses how to use the graphics to explain the VOI results to a Decision Maker.

Given P10-P50-P90 Points from a distribution, how can we sample from that distribution. Please see my updated video that shows easily creating a cumulative distribution graphic using SIPmath. https://www.youtube.com/watch?v=MkvGn...

Describes the Metalog distribution available in SIPmath that creates a continuous distribution with percentiles 10%, 50% and 90%. Lower and upper bounds can also be set. SIPmath tool bar can be downloaded from ProbabilityManagement.org

Part 2 Optimizes the portfolio based on the EV NPV, Sharp Ratio and Maximizing the P10. Compares the results and the portfolio composition of multiple ETFs. Excel model used is available at https://1drv.ms/x/s!AgtEj5D79IYqgctBj... or contact me at Brian@theputts.com