Non-Excel tools¶
ModelX¶
https://docs.modelx.io/en/latest/
modelx is a Python package to build object-oriented models consisting of formulas and values to carry out complex calculations. You can think of it as a hierarchical and multidimensional extension of spreadsheet, but there’s so much more to it!
modelx enables you to interactively develop, run and scrutinize complex models in smart ways:
- Only basic Python knowledge required
- Formulas defined by Python functions
- Object-oriented, supports composition and inheritance
- Parameterization
- Dependency tracing
- Reading from Excel and CSV files
- GUI as Spyder plugin (spyder-modelx)
- Saving to text files, enabling use of version control systems
- Document integration enabling use of document generators
- Pandas interface