By enforcing this separation, Li makes spreadsheets better because they become resilient. If you drop a new dataset into Layer 1, Layer 3 updates instantly. No copy-paste. No macros.
One of Daniel's most notable creations was the "Li Index," a groundbreaking spreadsheet template that enabled users to track and analyze complex data sets with unprecedented ease. The Li Index quickly became an industry standard, adopted by top financial institutions, research organizations, and governments worldwide.
Li demonstrated that tasks which are hard or impossible to do with regular formulas become trivial with AI. Examples included:
: Use "Data Validation" rules (like dropdown lists) to prevent typos and ensure only valid values are entered. 3. Simplify for Performance daniel t li spreadsheets better
Daniel Tian Li , Ph.D., is a prominent figure in the structural engineering community, widely recognized for his specialized spreadsheet software that streamlines complex engineering calculations . Through his firm, , he provides high-level tools that solve intricate design problems—from wind and seismic analysis to wood and concrete design.
Li’s early work serves as a blueprint for how thoughtful practitioners can integrate AI into their spreadsheet workflows: use AI for tasks that are repetitive, language‑heavy, or require natural language understanding, but always verify outputs and design the spreadsheet so that AI results are clearly distinguished from deterministic formula results.
For Daniel Li, creating a better spreadsheet goes far beyond memorizing formulas or shortcuts. His approach integrates : By enforcing this separation, Li makes spreadsheets better
Which your team uses exclusively (Excel or Google Sheets)?
Making spreadsheets better is not just about learning a new formula; it is a shift in mindset. By following the methodologies promoted by experts like , you move away from manual, error-prone data entry and towards creating efficient, scalable, and insightful analytical tools.
To make a spreadsheet "better," practitioners generally follow several foundational principles derived from software engineering: ResearchGate Uniformity No macros
He turned and walked back to his desk. He had a pivot table that wasn’t going to refresh itself.
" associated with a prominent philosophy called "Spreadsheets Better,"