Modelling & Simulation
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 ExcelFrome recommend it for your next project.
Modelling and simulating in Excel – the advantages
1. Harness Excels mathematical abilities with minimal effort
Save development time. Use VBA and libraries such as NAG to expand on its abilities when necessary.
2. Specialist knowledge on the subject
At ExcelFrome we have specialised expertise, in modelling physical, biological and business systems
3. Analyse Data FAST
Use Excel Pivot tables, Data Models, Formulas and Functions. Then use Excel Macros to push your productivity to the next level.
4. Display your results
Then display and present your new results, in a stunning dashboard report.
5. Connect to data sources with ease
Excel is almost without parallel when it comes to connecting to data sources. If it can’t connect ‘out of the box’ its usually an easy matter to write a data loader for your data.
The kinds of questions our customers ask us.
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
Its used in many fields of study such as energy, manufacturing and finance. As well as project management,transport and environmental, to name a few.
A Monte Carlo simulation thus helps you, the decision-maker to explore various choices of action. Safely and without any real risk.
For each choice of action you explore with the model, You will see a range of possible outcomes. with a predicted likely hood of these outcomes occurring. So you can explore the whole range of possibilities, from conservative ‘hands off,’ through to ‘going for broke.’
Excel Modelling and Simulation Case Studies
Property Portfolio Management Spreadsheet We built the Property Portfolio Workbook for an estate agency that wanted to keep track of their clients portfolios of property investments. The idea was that the agent [...]
Science dashboard in Excel A Science Dashboard using Excel offers the combination of a very powerful analysis engine, matched with a colourful and animated front end. We use VBA and .net languages [...]
Environmental Modelling – Monitoring and Models 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 [...]
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 [...]