I think simulation/modelling is one of the most exciting operations that you can do in Excel. I’ve written models the long way and the shorter way, and Excel can be a real time saver.
There is no better way of ‘getting under the skin’ on a problem than to simulate and model it. Excel is an excellent platform for both, and we at Excel Frome recommend it for your next project.
We can harness Excels mathematical abilities with minimal effort, thus saving development time. Then use VBA and libraries such as Exist or NAG to expand on its abilities when necessary.
At Excel Frome we have specialised expertise, in modelling physical, biological and business systems.
One system we have built several times is the Monte Carlo simulation, which is very well suited to Excel ..
What is Monte Carlo Simulation?
|A Monte Carlo simulation, is a mathematical technique, conducted on a computer. Which allows us to account for risk in our decision making. In an unpredictable world, such a system can be very useful. Read More about Monte Carlo|
What is Excel Modelling and Simulation?Wikipedia entry – Read More
Excel Modelling and Simulation
Environmental Modelling – Monitoring and Models There is a real need for mathematical models that simulate or model various environmental modelling systems, such as water or air quality. Environmental quality measurements taken in the field need to be fed into … Continue reading →
Estimated Driving Times Estimated driving times can play a vital role in spacial data analysis. Customer address lists can be fed into a GIS system and processed to find out how local they are, how long it may take to … Continue reading →