Spry brings to MS Excel additional spreadsheet functions that represent event generators, queues, state variables, delays, loops and other simulation elements that you can connect together while designing the model in spreadsheet.
During simulation run, Spry mimicks the passage of time by recalculating the model several times, for each consequtive time period. Data collection and statistics for specific cells in the model that interest you is also arranged as a spreadsheet function. Besides this, simulation models usually include stochastic variables, so to get reilable results Spry can repeat the whole model several times.
You can make the first steps in Spry by following the tutorials. The examples used in the tutorials are available in this repository:
- Simple chaotic system
- Discrete-event model (barbershop example)
- System dynamics (Bass diffusion of innovations model)
- Mixed model with optimization (inventory)
Extensive documentation is available here.
You can download add-in and request trial license here.
Copyright (c) 2023 ABS CENTER Koper d.o.o.