In simple English
Spreadsheets are hard to check when formulas are written by hand. This tool lets you write financial models in Python instead. It turns your code into a real Excel file with working formulas. When you change an assumption, the whole sheet recalculates just like a hand-built workbook. It is free to use and runs on your own computer.
What it is
A Python library that compiles dependency graphs into Excel workbooks with live formulas. It tracks cell references across sheets and builds recurrence series for financial forecasting.
What it is good for
Solo founders and financial analysts who want to build complex forecasts in code while keeping the final output in a familiar spreadsheet format for clients or investors.
- Writes real Excel formulas instead of static numbers.
- Tracks dependencies automatically across different sheets.
- Includes an interactive HTML view for Jupyter notebooks.
- Requires Python programming knowledge to write and update models.
- Limited to the built-in set of translated spreadsheet functions.
- Debugging broken formulas requires tracing through Python code.
Writing raw Excel formulas by hand or generating static CSV files from scripts
Jupyter notebooks for interactive model exploration
- meilisearch/meilisearch59k stars
A search engine you run yourself, built for fast answers and forgiving spelling.
- beekeeper-studio/beekeeper-studio24k stars
A desktop window onto a database, so you can read and edit rows without writing commands.
- sqliteai/sqlite-vector1.1k stars
An add-on that gives the single-file SQLite database meaning-based search, with its own accuracy figures printed in the README.
pip install modeleon