Crystal Ball is a simulation tool to easy-of-use that helps the professionals of several industries to analyze the risks and uncertainties that are modeled inside of electronic spreadsheets of Microsoft Excel.
Usually, the models in MS Excel are deterministic. This means that the input is fixed to a value to a cell. The analyst can only see a solution of every time. A simulation of Monte Carlo is a way to generate quickly and to analyze many possible results. MS Excel cannot run these simulations by itself and an Add-In like Crystal Ball is necessary so that MS Excel can make this.
Most of the models used in most of the industries uses stochastic variables as building blocks. Although the exact values of the variables are difficult to predict, a lot of times important information that considers these parameters is available for analysis of historical data, or for the Gut feeling and experiences of the author of the model. Crystal Ball allows an integration easy of the excel model by using probability distributions selected in order to describe the behavior of the variables. A sophisticated model is built like this. Monte Carlo's simulations test the model for a big number of attempts. The forecast values are posted in a frequency table and several statistical reports that allow valuable conclusions relative to the forecast.
Crystal Ball is becoming the reference tool of Monte Carlo models for several sectors of the industries. Stachanov won a complete experience with the following solutions that we have been offering to our customers
License consulting and sales
Companies and private clients have the option to order their Oracle Crystal Ball licenses from Stachanov directly at the Oracle rates and conditions. The advantage of working with Stachanov is the excellent service that is provided for smaller and larger orders, and the availability of consultants that are ready and willing to answer the clients’ questions. Stachanov supplies among others ProRail, the Amsterdam Construction Agency (IBA), the Ministry of Agriculture, and BAM Group.
Stachanov has delivered lectures at the VU University in Amsterdam, the Vlerick School of Management in Louvain and Ghent, the Netherlands Business School Nyenrode, and the University of Santiago de Compostela. Open courses were organised in cooperation with Oracle in Paris, Brussels, London, Frankfurt, Zürich, and Amsterdam. Applications have been developed for Merck-Serono in Darmstadt and Geneva, Vesteda in Amsterdam and Maastricht, and for the Agence de Transfert de Technologie Financière (ATTF) in Luxembourg.
Besides standard training, we can offer customised training that are highly specialised and tailored to your own needs and interests.
Industry sectors that we have in-depth industry knowledge about include Consulting and education, banking and finance, oil, gas and energy, healthcare and pharmaceutical, transport and traffic, manufacturing and education.
Stachanov harbours a team of highly qualified mathematicians and excel specialists, which enables us to build excellent models, whether conceptual, interactive or financial.
Additional MS Excel add-in expertise and consulting
Besides deep knowledge about the Crystal Ball add-in for Excel, we are specialised in a wide variety of Excel add-ins regarding statistical computing, and the auditing of spreadsheets. The latter typically sell as a package with any other add-in, as audit add-ins allow for cleaning up, rationalising, and, truly understanding spreadsheet models.