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.

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

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.

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.

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

Demonstrates generating 10 metalogs using the One-Line Metalog. Contact me Brian@theputts.com for the Excel file.

How to generate a discrete distribution with SIPmath Modeler Tools and create cumulative distribution graphs (CDF). Compare two CDFs on the same chart

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

Brian Putt discusses the advantages of SIPmath

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

Best Birthday Problem with distribution of how many couplets in class of 30. Excel model developed with free SIPmath tool. Excel model available on request.

Calculate the probability that a task is on the critical path when all of the tasks are uncertain. Explained through a live Excel model. Contact me for a copy of the model. Brian@theputts.com See my other videos on Cost and Schedule Risk

Describes the Joint Confidence Level (JCL) graphic used to analyze a cost and schedule risk analysis using Excel. Demonstrates sensitivity to the confidence level and multiple ways to achieve the objectives using Excel.

Part 4 - Working only with Excel we optimize the ticket price for the reference case and compare that to the optimized decision policy and ticket prices with imperfect information. Evaluation conduced using simulation and Excel Solver rather than using decision trees.

Probabilistic tornados show the impact of the low and high values on the EV of the value function. This eliminates the confusion why the EV of the distribution is not the center line of the tornado which occurs with the deterministic tornado. We show the difference in an excel model

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

Brian Putt discusses the advantages of SIPmath

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