Today sees the launch of my Interactive Web Consultation service. This allows one-to-one consultations using a high-quality internet video conferencing services over the internet in which applications (such as Excel, Excel-add-ins such as @RISK, PowerPoint and Word) can be shared. This provides an opportunity to jointly work on a model or document. [Read more…] about Launch of Web Consultation Service
Archives for November 2010
Following the earlier blog about the use of user-defined functions in VBA code to model time delays in Excel, I am here posting a similar example, but which is more general and allows for both lead times, as well as lag time; that is projects or cash flows can brought forward according to some allocation mechanism as well as delayed. The advantage of this extra flexibility is to avoid having to set up models in which the base case is the most optimistic one possible, and in which any deviation is necessarily a delay. Rather, the base case can be more flexibly defined and the used case adapted from that in either time direction (for each variable). [Read more…] about Modelling Time Leads and Lags
This blog continues the series on self-diagnosis questions about risk modelling covers issues relating to the use of key probability distributions within @RISK. There will be three further postings on this topics priort to Christmas, to complete the series. I’ll also be posting more on modelling leads and lag times through VBA code. [Read more…] about Self-Test Questions 4: Further Uses of Distributions in @RISK
Streamlining a model is important to reduce error, time consumption and its overall complexity. As mentioned in an earlier blog, one key area where models can become large, complex, and inflexible, it in the implementation of time delays, such as where a project start date may need to be changed (or is uncertain), where receivables may be received at a future date that may need to be changed, or where a quantity needs to be allocated across time, such as for depreciation schedules, tax calculations, or in insurance loss triangles. In this blog, we show how such topics can most efficiently be implemented through the use of user-defined functions in VBA. [Read more…] about Modelling Time Delays and Loss Triangles
This third set of self-diagnosis questions about risk modelling covers issues relating to the key probability distributions. Once again, test yourself to see how much you know!! [Read more…] about Self-Test Questions 3: Probability Distributions: Key Types
This second set of self-diagnosis questions about risk modelling covers issues relating to key terms relating to probability distributions. The blog following this one will cover topics relating to the key types of individual distributions. [Read more…] about Self-Test Questions 2: Probability Distributions – Key Terms
Leading up to Christmas, I will be posting a series of blogs containing a set of questions in topics related to risk modelling, probability distributions, their use within @RISK™, key features of @RISK and its applications, as well as issues relating to the wider set of products in Palisade’s DecisionTools Suite. These questions can be used to test your knowledge!