Daniel T Li Spreadsheets Better May 2026

Daniel T. Li is a prominent structural engineer known for developing a massive suite of specialized structural design spreadsheets and web-based software through Engineering International. His approach emphasizes making complex engineering calculations "better" by automating tedious code requirements and providing clear, reproducible outputs. Overview of Daniel T. Li’s System

The core value of Li's system is its breadth, covering nearly 500 different structural design tasks across various materials and codes. His spreadsheets are designed to streamline:

Concrete Design: Includes two-way slabs, circular columns, and specialized shear walls based on ACI 318-11/14.

Wood Design: Features tools for perforated shear walls, wood beams, and diaphragms based on NDS 2012.

Lateral Analysis: Comprehensive tools for wind and seismic analysis according to ASCE 7-10/16.

Foundation Design: Covers wall footings and combined footings. How to Use These Tools for "Better" Engineering

To get the most out of these spreadsheets, follow these guiding principles from the Daniel T. Li User's Book and peer reviews:

Prioritize Behavioral Understanding over ComputationAs highlighted in Eng-Tips discussions, you should never trust software blindly. A "better" spreadsheet user ensures they can replicate the method by hand before relying on the automated output for final designs.

Focus on ConstructibilityLi’s tools often provide optimized results, but better engineering requires evaluating these for real-world application. For example, avoid excessive optimization that makes similar members slightly different in size, which complicates on-site construction.

Cross-Verify Conservative ResultsReviewers on Eng-Tips have noted that Li's spreadsheets, such as those for combined footings, can yield conservative results compared to traditional methods. Use this conservatism as a safety check rather than a rigid rule.

Leverage Visual Outputs for Sanity ChecksEach software package typically includes graphic drawings and formula references. Use these visualizations to immediately identify if the loading or geometry input matches your physical design intent. Best Practices for Spreadsheet Management

Whether using Li’s templates or building your own "better" sheets, follow these professional standards:

Clear Units: Always explicitly state units and number formats to prevent catastrophic input errors.

Simplified Formulas: If you modify the sheets, break complex multi-step formulas into multiple cells to make them easier to review and audit.

Data Integrity: Hide or protect cells that contain core code formulas to prevent accidental overrides while leaving input fields clearly labeled. 20 principles for good spreadsheet practice - ICAEW.com

Pillar 1: The "Reference, Not Value" Paradigm

The first lesson in the Daniel T. Li playbook is the shift from storing values to storing references.

In a classic spreadsheet, if you type "Q1 Sales," that is a static string. If you change the quarter, you have to edit the cell. Li’s "better" approach treats every cell as a potential query.

The Technique: Instead of hardcoding labels or constants, Li advocates for dynamic named ranges and what he calls "Semantic Arrays." For example, instead of =SUM(A1:A100), he would write =SUM(Filter(Transactions, Month = "March")).

Why is this better? Because the second method describes the intent, not just the location. When the data moves, the formula doesn't break. This borrows concepts from database normalization (SQL) but keeps them inside the spreadsheet grid.

The Tools of the Trade

When people search for "daniel t li spreadsheets better," they often want to know what software he uses. His stack is agnostic but opinionated:

For heavy logic: Excel for Desktop (Microsoft 365) – due to superior LAMBDA performance and Power Query.
For collaboration: Google Sheets – but strictly enforcing the Green-Yellow-Red framework.
For the bridge: He often uses Row Zero or Equals (modern spreadsheets) for datasets that exceed 1 million rows, applying the same logical principles.
No-Code Automation: He integrates Make.com or Zapier to handle the "export" step, ensuring raw data lands perfectly formatted in Layer 1.

Pillar 2: Automation via Logic Layers (No VBA Required)

Most "spreadsheet experts" jump to VBA or Google Apps Script when a task becomes repetitive. Daniel T. Li argues that scripting is often a crutch that creates "black boxes" which future users cannot understand.

Instead, Li developed a methodology called "Three-Layer Logic."

Layer 1 (Data): Raw, untouched import data. Never edit this. It is your source of truth.
Layer 2 (Enrichment): Helper columns using LET and LAMBDA functions (Excel) or MAP and FILTER (Sheets). This is the "engine."
Layer 3 (Presentation): The final output, which is purely references to Layer 2.

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.

Overview: What is "Spreadsheets Better"?

Spreadsheets Better is an educational platform founded by Daniel T. Li that focuses on advanced spreadsheet techniques, specifically bridging the gap between basic Excel/Google Sheets usage and professional-level automation, data analysis, and formula optimization. Li’s core philosophy is moving beyond manual cell formatting and simple SUM functions toward dynamic, error-resistant, and scalable spreadsheet design.

Key Areas of Expertise

Daniel T. Li’s content is particularly strong in three interconnected domains:

Array Formulas & Dynamic Arrays: He extensively teaches how to use FILTER, SORT, UNIQUE, SEQUENCE, and LAMBDA functions (in Excel) and their Google Sheets equivalents. Instead of writing a formula for one cell and dragging it down, he shows how to write a single formula that spills results across multiple rows/columns automatically. daniel t li spreadsheets better
Data Validation & Dropdowns: Li emphasizes using dependent dropdown lists, custom formulas in validation rules, and combining data validation with INDIRECT or XLOOKUP to create interactive, database-like behavior inside a spreadsheet.
Automation without Scripts: A standout feature of his teaching is achieving complex automation using only native functions—no VBA (Excel) or Apps Script (Google Sheets) required. For example, building a self-updating project tracker, a search box that filters a database in real time, or a calendar that highlights conflicts.

The Problem: The "Grid Ceiling"

Before we discuss the solution, we must define the pain point. Daniel T. Li argues that traditional spreadsheets hit a "Grid Ceiling" when datasets exceed 100,000 rows or when the logic requires more than three nested IF statements.

Traditional spreadsheets are terrible at three things:

Version Control: Emailing "Final_v3_FINAL_actuallyFINAL.xlsx" is a symptom of a broken system.
Auditability: Tracing a #REF error through a massive workbook often takes longer than rebuilding the sheet from scratch.
Reproducibility: If you manually color a cell red, the spreadsheet has no memory of why you did that.

Li’s work focuses on breaking this ceiling. He doesn't want to kill the spreadsheet; he wants to augment it.

Real-World Application: A Case Study

To understand "Daniel T. Li spreadsheets better," look at his work with a mid-sized e-commerce logistics firm.

The Old Way: The firm used a 50MB Excel file. It crashed twice a day. Three analysts spent 15 hours a week reconciling inventory because the master sheet used volatile functions (OFFSET, INDIRECT) that recalculated every time you scrolled.

The Li Way (Results):

Refactoring: Li replaced all volatile functions with INDEX/MATCH and XLOOKUP.
Automation: He built a LAMBDA called GetStockStatus that pulled live data from a CSV export, cleaned it, and flagged low items in 0.3 seconds.
Visualization: He replaced colored cells with a conditional formatting rule based on a hidden helper column (Layer 2).

The Outcome: The file size dropped to 12MB. Calculation time went from 45 seconds to 2 seconds. The three analysts were freed up to do actual analysis instead of data janitor work.

The Verdict: Why This Matters Now

AI is coming for the spreadsheet. Microsoft has Copilot. Google has Duet AI. But Daniel T. Li argues that AI will not fix bad architecture. If your spreadsheet is a mess of hard-coded values and broken links, an AI cannot fix it—it will just hallucinate worse numbers.

Making spreadsheets better, according to Li, is the prerequisite for AI integration. A clean, LAMBDA-driven, three-layer spreadsheet is a spreadsheet that an AI can actually understand and manipulate on your behalf.

If you are tired of feeling like your spreadsheet owns you, search for Daniel T. Li on LinkedIn or GitHub. Review his open-source templates. Watch his breakdown of MAP and REDUCE functions.

The era of the fragile, manual, cell-by-cell spreadsheet is ending. The era of the spreadsheet as a structured, reusable, functional application is beginning—and Daniel T. Li is leading the charge.

Stop fighting the grid. Start making it better.

Are you implementing Daniel T. Li’s spreadsheet methods? Share your "before and after" stories in the comments below.

The Invisible Foundation: Engineering Better with Daniel T. Li’s Structural Spreadsheets

In an era of increasingly complex 3D modeling and black-box software, there is a quiet revolution happening at the intersection of traditional engineering rigor and digital efficiency. For structural engineers, the name Daniel Tian Li, Ph.D., and his platform, Engineering International, represent a shift toward transparent, accessible, and high-utility design tools.

His library of over 495 structural design software modules—essentially highly specialized "super-spreadsheets"—is changing how professionals approach everything from seismic analysis to masonry. Here is a deep dive into why these tools represent a "better" way to engineer. 1. Transparency Over the "Black Box"

One of the primary critiques of high-end 3D modeling software is the "black box" effect, where results are produced without the user seeing the underlying logic. Li’s spreadsheets flip this script.

Formula Visibility: Each module explicitly contains the formulas and reference code sections (such as ASCE 7-22 or ACI 318-11) used for calculations.

Traceability: Because they are grounded in spreadsheet logic, engineers can trace the "what and why" of a decision, which is critical for peer reviews and professional accountability. 2. Specialized Precision for Complex Standards

Rather than offering a one-size-fits-all program, Daniel T. Li provides granular tools for specific, high-stakes tasks:

Seismic & Wind Analysis: Detailed spreadsheets for Lateral Analysis Groups, including Equivalent Lateral Force Procedures and Modal Response Spectrum Analysis based on the latest ASCE 7-22 standards.

Material Diversity: Specialized modules exist for Steel, Concrete, Wood, Masonry, and Aluminum, ensuring that the unique physics of each material is respected. 3. The "AI-Powered" Evolution

While these tools originated as traditional spreadsheets, Li has evolved them into a hybrid system using AI-powered methods for HTML input and PDF output. Daniel T

Web-Enabled Efficiency: Professional versions allow users to save HTML input files for future use, bridging the gap between a static Excel file and a dynamic web application.

Visual Documentation: Each calculation is accompanied by graphic drawings, turning raw data into a structured report ready for official submission. 4. Professional Reliability

Daniel T. Li isn't just a programmer; he is a Registered Structural Engineer (S.E.) in California and a Chartered Structural Engineer in the UK. This professional pedigree ensures that the software isn't just mathematically sound—it's practically applicable to real-world building codes. The Verdict: Why "Better"?

"Better" in engineering doesn't always mean "more complex." It means more reliable, more transparent, and faster to verify. By stripping away the bloat of traditional CAD-heavy software and focusing on the core calculation, Daniel T. Li’s spreadsheets allow engineers to get back to what they do best: making informed, safe, and code-compliant design decisions.

You can explore the full Software Overview or Resume of Daniel T. Li to see which tools fit your current project.

If you tell me which structural material (e.g., steel, concrete) or specific code (e.g., ASCE 7-22) you're working with, I can find the exact Daniel T. Li module that matches your needs. ACM Queue: ACMQ Site

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, Engineering International Inc., he provides high-level tools that solve intricate design problems—from wind and seismic analysis to wood and concrete design.

Here is how Daniel T. Li's spreadsheets make the engineering process "better," alongside general best practices for mastering spreadsheet design. Why Daniel T. Li Spreadsheets are "Better"

For professional structural engineers, Li's spreadsheets offer several distinct advantages over manual calculations or general-purpose software:

Automation of Complex Codes: His sheets are meticulously updated to reflect current building codes, such as ASCE 7-16 for wind and seismic analysis or ACI 318-14 for concrete.

Specialized Engineering Tasks: Instead of generic math, these sheets handle niche problems like rotation analysis of rigid diaphragms, discontinuous shear wall analysis, and composite strong wall design.

Verification and Transparency: Many engineers prefer Li's sheets because they provide a bridge between "black box" commercial software and manual verification, allowing for auditable results.

Efficiency: They are often cited as excellent supplements to larger programs like Enercalc, especially for specific tasks like joist or beam calculations. General Principles for Making Spreadsheets Better

Whether you are using specialized structural tools or building your own, following these core design principles ensures your spreadsheets remain reliable and user-friendly. 1. Prioritize Clarity and Organization

Uniform Formatting: Use consistent fonts, colors, and borders to create a cohesive look.

Dedicated Input Sections: Ensure all user-defined data is entered in one clearly marked section to avoid hunting through the sheet for variables.

Label Everything: Every column and row should have a clear header. Use a "data dictionary" if your variables are complex. 2. Optimize for Accuracy

One Fact per Cell: Do not combine multiple data points into a single cell.

Avoid Hidden "Data": Never use font color or highlighting as the only way to categorize data, as this cannot be easily read by formulas.

Data Validation: Use "Data Validation" rules (like dropdown lists) to prevent typos and ensure only valid values are entered. 3. Simplify for Performance

Here is the requested report based on Daniel T. Li's perspectives on spreadsheets and modern data tools. 📊 Executive Summary

The phrase "Daniel T. Li spreadsheets better" refers to the thesis popularized by Daniel T. Li (partner at Madrona Venture Group) that software startups should not try to replace spreadsheets, but rather build tools that work on top of them or replicate their core UX [1, 2]. Spreadsheets are the ultimate flexible computing environment, and the best founders leverage this instead of fighting it [1]. 🔑 Key Concepts of the "Better Spreadsheet" Thesis 1. The Power of the Spreadsheet UX

Visual Grid: Users instantly understand rows, columns, and cells.

Instant Feedback: Changing a cell updates the entire sheet immediately.

Low Code: Formulas allow non-technical users to build complex logic. Pillar 1: The "Reference, Not Value" Paradigm The

Ultimate Flexibility: Users can mash together unstructured data with zero setup. 2. Why Founders Fail to Replace Them

Over-specialization: Custom SaaS tools solve one problem perfectly but break when the user's workflow changes slightly.

High Friction: Moving data out of a grid into a structured database feels restrictive to business users.

The "Export to CSV" Trap: No matter how good a SaaS product is, users almost always end up clicking "Export to Excel" to do their actual analysis. 3. The Strategies for "Better" Spreadsheet Tools

Instead of competing with Excel and Google Sheets, modern successful software companies generally fall into three categories:

Spreadsheet as the UI: Building products that live directly inside Excel or Google Sheets (e.g., live data connectors).

Supercharged Spreadsheets: Platforms that look and feel like a spreadsheet but have a powerful database or automation engine under the hood (e.g., Airtable, Smartsheet, Coda).

The "Unbundling" Method: Taking a specific, massive use case currently handled by messy spreadsheets and building a dedicated workflow tool for it (e.g., financial planning or cap table management). 🚀 Strategic Recommendations for Founders

🎯 Embrace the Grid: If you are building a B2B data tool, use a grid layout for your interface to reduce user learning curves.

🔌 Build Native Integrations: Ensure your software reads from and writes directly to Google Sheets and Excel from day one.

🛠️ Observe Shadow IT: Look at what complex models your target customers are building in Excel today; those are the perfect candidates for your new software product.

Unlocking the Power of Spreadsheets with Daniel T Li

In today's data-driven world, spreadsheets have become an essential tool for businesses, organizations, and individuals alike. However, making the most out of spreadsheets requires more than just basic knowledge of formulas and functions. This is where Daniel T Li comes in - a renowned expert in spreadsheet development and optimization.

Who is Daniel T Li?

Daniel T Li is a highly skilled professional with extensive experience in creating and improving spreadsheets. With a passion for data analysis and visualization, Daniel has helped numerous clients across various industries to develop efficient, effective, and user-friendly spreadsheets.

The Art of Spreadsheets: Why Daniel T Li Stands Out

What sets Daniel T Li apart from others in the field is his unique approach to spreadsheet development. He believes that a well-designed spreadsheet is not just about formulas and functions, but also about storytelling and visualization. Daniel's expertise lies in crafting spreadsheets that are not only accurate and efficient but also intuitive and engaging.

Developing an Interesting Content with Daniel T Li

So, how can Daniel T Li help you develop an interesting content using spreadsheets? Here are a few ways:

Data Visualization: Daniel can help you create stunning visualizations that bring your data to life. With his expertise in charting and graphing, he can transform complex data into easy-to-understand insights.
Interactive Dashboards: Daniel can design interactive dashboards that allow users to explore data in real-time. With his knowledge of advanced formulas and functions, he can create dynamic dashboards that respond to user input.
Storytelling with Data: Daniel believes that data should tell a story. He can help you craft a narrative around your data, making it more engaging and memorable for your audience.

Benefits of Working with Daniel T Li

By working with Daniel T Li, you can:

Improve Data Accuracy: Daniel's attention to detail ensures that your spreadsheets are accurate and reliable.
Enhance User Experience: Daniel's expertise in user interface design ensures that your spreadsheets are intuitive and easy to use.
Increase Productivity: Daniel's optimized spreadsheets can save you time and effort, allowing you to focus on higher-value tasks.

Get in Touch with Daniel T Li

If you're looking to take your spreadsheet game to the next level, look no further than Daniel T Li. With his expertise and passion for spreadsheet development, Daniel can help you create interesting and effective content that engages your audience.

Contact Daniel T Li today to learn more about his services and how he can help you unlock the power of spreadsheets!

Note: "Daniel T. Li" is most prominently known as the creator of the Spreadsheets Better platform (formerly a popular YouTube channel and educational website). There is no separate product called "Daniel T. Li Spreadsheets Better"; rather, the phrase refers to his overall teaching brand.