Powering Energy Storage Beyond Excel
summary
Company moves dozens of Excel workbooks into a tested web app that actually runs the battery sizing math: Jupyter notebook prototypes validate formulas and catch Excel vs Python precision issues (Excel’s 15 significant digits vs Python decimals), then code lands in Django + PostgreSQL + DRF with Next.js/Ant Design UI, CSV/PDF exports, Celery for jobs. Repository and a management command that imports Excel exist. Tests reveal real bugs (JSON integer-keys → strings, rounding mismatches) and the app replaces fragile file-versioning.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:23Energy storage challenges
- 4:13Excel fails for complex calculations
- 8:23Django for this project
- 11:59Change management
- 13:24Prototyping with Jupyter
- 16:57Excel vs Python math
- 22:18Django backend
- 23:43Next.js and Ant Design frontend
- 26:32Excel to Django challenges
- 29:04Testing formulas in Django
- 32:19When to transition
- 33:00Q&A
related talks
39mPython & Spreadsheets: 2017 Edition
24mHow to build a spreadsheet with Python
01h 25mAdvanced Excel Analytics: Python Integration Workshop
02h 52mFrom Spreadsheets to DataFrames
01h 18mKeynote
30mEmpowered by Python - A success story
01h 50mSpreadsheet-Driven Meta-Programming for Python
21mSoftware Best Practices for Data Pipelines: Form Energy's Multi-Day Storage R&D Pipeline 🌳