Daniel T Li Spreadsheets -

As of 2025, spreadsheets are evolving. Excel now supports Python. Google Sheets has =PY. Does Li’s approach become obsolete?

Ironically, no. Li argues that AI and Python make his principles more critical. When you embed a Python script or an =GPT() call in a cell, the fragility multiplies. You now have non-deterministic outputs. His referential integrity and separation of layers become essential to debugging whether an error came from a Python library update or a wrong cell reference. daniel t li spreadsheets

Li currently advocates for a hybrid model: As of 2025, spreadsheets are evolving

Li famously despises "junk-drawer" spreadsheets where formatting, raw data, and formulas collide. He mandates a strict physical separation: In Li’s words: "If you are changing a

In Li’s words: "If you are changing a font color in the same cell where you are calculating CAGR, you have already lost."

Perhaps Li’s greatest contribution to the field is his concept of the Anti-Fragile Spreadsheet. In finance, a fragile spreadsheet breaks when you add a row. A robust spreadsheet handles a row addition. An anti-fragile spreadsheet gets better when you add data.

How does he achieve this?