Daniel T Li Spreadsheets May 2026

Daniel T. Li, Ph.D., S.E., is a prominent figure in the field of structural engineering, best known for developing an extensive library of professional structural design spreadsheets through his company, Engineering International Inc..

These tools are widely recognized in the engineering community for their ability to streamline complex calculations for various structural materials and systems while ensuring compliance with rigorous building codes. The Core Offering: Engineering International Spreadsheets

The primary focus of Daniel T. Li’s work is a collection of approximately 495 structural design software modules. These tools are built using Microsoft Excel (specifically .xlsb and .xlsm formats) and are designed to provide a comprehensive, transparent, and easy-to-use platform for structural analysis. Key Categories of Design Spreadsheets:

Concrete & Masonry: Includes designs for beams, columns, walls, and slabs, often following ACI 318 standards.

Steel Design: Extensive tools for I-beams, wide flange members, and plate girders based on AISC Manual specifications.

Wood & Aluminum: Specialized spreadsheets for timber analysis and aluminum member capacity.

Foundations & Retaining Walls: Solutions for footing design, pile capacity, and seismic lateral analysis.

Specialty Structures: Tools for glass design, tunnel design, and even bridge components based on AASHTO standards. Why Engineers Use Daniel T. Li’s Tools

Structural engineers often prefer these spreadsheets over "black-box" software because they offer a higher degree of transparency and flexibility.

Code Compliance: The spreadsheets are regularly updated to reflect the latest versions of the International Building Code (IBC) and California Building Code (CBC).

Transparent Calculations: Unlike complex analysis programs, these sheets show the formulas and reference code sections used, making them ideal for submittals to building departments.

Ease of Use: Users typically only need to input values into designated cells (often highlighted in green), and the tool automatically generates the results and drawings. daniel t li spreadsheets

AutoCAD Integration: Analysis results and drawings from the spreadsheets can often be copied and pasted directly into AutoCAD for detailing. Licensing and Accessibility

The software is licensed through Engineering International Inc. rather than sold as individual files.

Package Model: DTL generally does not sell individual software modules because the databases are often interlinked. Instead, users purchase a license for the entire package of hundreds of spreadsheets.

Demo Versions: Free "limited" or demo versions are often available for download on the official site so engineers can test the input/output interface before committing to a professional license.

Updates: Licensed users can pay an annual upgrading fee to receive new software released throughout the year and stay current with code changes. About the Developer

Daniel Tian Li is a highly qualified professional with multiple credentials, including: Ph.D. in Engineering. Licensed Structural Engineer (S.E.) in California.

Chartered Structural Engineer in the United Kingdom (MIStructE). Licensed General Engineering Contractor.

His diverse background in both engineering design and construction contracting informs the practical, "builder-friendly" nature of his spreadsheet tools. Structural Design Software

The "solid feature" you are likely referring to is the structural analysis and design logic

embedded within the "Daniel T. Li" spreadsheets, which are widely recognized in the civil and structural engineering

community for their comprehensive coverage of complex design codes. Engineering International Daniel T

Daniel Tian Li, Ph.D., an SE from California, developed a suite of professional-grade Excel spreadsheets through Engineering International that handle various structural components: Engineering International Design Scope:

The spreadsheets cover materials such as wood, concrete, steel, aluminum, glass, and masonry, as well as specific structures like bridges, retaining walls, and tunnels. Ease of Use:

A hallmark feature is the user-friendly interface where engineers only need to input values in green-colored cells to receive automated calculations and results. Compliance: They are built to comply with major codes, including AASHTO 17th Edition ACI 318-11 AISC Manual 14th Edition Professional Output:

Many users find them a solid alternative to expensive commercial software because they generate polished PDF design reports that can be used directly in project submittals. Engineering International

While these tools are highly regarded for their "in-house" feel and robustness, users should note they are often password-protected

to prevent accidental formula alterations, which can limit customization. specific structural template

Daniel T. Li Spreadsheets Report

Introduction

This report provides an overview of Daniel T. Li's work with spreadsheets. As a renowned expert in spreadsheet applications, Daniel T. Li has made significant contributions to the field, developing innovative solutions and sharing knowledge with the community.

Key Achievements

Spreadsheet Expertise: Daniel T. Li has extensive experience in creating and managing complex spreadsheets for various industries, including finance, accounting, and data analysis.
Template Development: He has developed numerous spreadsheet templates for specific business applications, such as budgeting, forecasting, and data visualization.
Training and Education: Daniel T. Li has provided training and education to individuals and organizations on effective spreadsheet usage, best practices, and advanced techniques.

Notable Projects

Financial Modeling: Daniel T. Li created a comprehensive financial model for a startup, enabling the company to forecast revenue growth and make informed investment decisions.
Data Analysis: He developed a data analysis spreadsheet for a research institution, facilitating the examination of large datasets and identification of trends.
Automation: Daniel T. Li designed and implemented an automated spreadsheet system for a manufacturing company, streamlining data entry and reducing errors.

Skills and Tools

Microsoft Excel: Daniel T. Li is proficient in advanced Excel skills, including VBA programming, pivot tables, and data visualization.
Google Sheets: He has experience with Google Sheets, including collaborative editing and add-ons.
Data Analysis and Visualization: Daniel T. Li is skilled in data analysis and visualization techniques, using tools like Power BI and Tableau.

Conclusion

Daniel T. Li's expertise in spreadsheets has made a significant impact in various industries. His ability to create complex spreadsheets, develop innovative solutions, and share knowledge with others has earned him recognition as a leading expert in the field.

Recommendations

Future Projects: Consider engaging Daniel T. Li in future projects that require advanced spreadsheet applications, data analysis, or automation.
Training and Education: Leverage his expertise to provide training and education to individuals and organizations seeking to improve their spreadsheet skills.

Appendix

List of notable projects and achievements
Examples of spreadsheet templates and solutions developed by Daniel T. Li
Testimonials from clients and colleagues

Key Formulas & Patterns

Prefer array-aware functions when available (Excel: dynamic arrays; Sheets: ARRAYFORMULA).
Use structured references or named ranges for readability:
- Excel table: =SUM(Table1[Amount])
Common formulas:
- SUMIFS for conditional sums: =SUMIFS(AmountRange, DateRange, ">=2026-01-01", CategoryRange, "Marketing")
- COUNTIFS for counts with multiple conditions.
- INDEX/MATCH (or XLOOKUP in Excel): =XLOOKUP(key, lookup_array, return_array, "Not found")
- VLOOKUP only if leftmost-key constraint is acceptable.
- FILTER (Sheets/Excel dynamic): =FILTER(Transactions, (Transactions[Date]>=A1)*(Transactions[Date]<=B1))
- UNIQUE + SORT for deduped lists: =SORT(UNIQUE(CategoryRange))
- TEXT and VALUE for conversions, e.g., =DATEVALUE("2026-04-11") or =TEXT(A1,"yyyy-mm-dd")
- IFERROR wrapping: =IFERROR(formula, "")
Use LET (Excel) to name sub-expressions for clarity and performance:
- =LET(x, FILTER(...), SUM(x))
Avoid volatile functions (INDIRECT, OFFSET, TODAY in heavy use) in large models.

Security & Sensitive Data

Keep secrets (passwords, API keys) out of spreadsheets; use environment-secure storage.
When sharing, sanitize PII from exported copies.

The "Anti-Fragile" Spreadsheet Methodology

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?

Dynamic Named Ranges: Using OFFSET and COUNTA, his tables expand automatically. No more updating ranges every Monday morning.
Structured References: He strictly uses Excel Tables (Ctrl+T) to ensure that formulas read =[@Revenue]-[@Cost] instead of =F2-G2.
The "Audit Tab": Every single one of Daniel T. Li’s spreadsheets includes a hidden "Audit" tab. This tab counts the number of hardcoded numbers in the sheet. If the count is more than zero, the sheet is considered "unreleased."

Tools of the Trade: Li’s Tech Stack

While Li respects Microsoft Excel, he is platform-agnostic. If you are looking to replicate his style, here is his current tech stack:

Excel (Desktop): For heavy financial modeling and XLOOKUP arrays.
Google Sheets: For collaboration. He is a master of Google Apps Script, often automating email sends directly from a sheet update.
Causal (Modeling): For probabilistic models, but he exports everything back into a spreadsheet for "legal documentation."
Python (Pandas): He uses Python to clean data before it ever touches his spreadsheet, but he refuses to use Python in the spreadsheet. "Data cleaning," he says, "is for scripts. Analysis is for grids."

Daniel T. Li and the Art of Spreadsheets

Daniel T. Li is recognized in niche finance and tech operations circles for transforming the humble spreadsheet from a basic data grid into a high-performance decision-making engine. While not a household name, his influence appears in case studies, online courses, and open-source templates that emphasize structured thinking, auditability, and automation within Excel and Google Sheets.

Core Philosophy

Li treats spreadsheets as software. His approach includes:

No hardcoded values – Every input lives in clearly labeled cells, often on a dedicated “Controls” or “Inputs” tab.
Color-coded cell conventions – Blue for inputs, black for calculations, green for references to other sheets, red for warnings/errors.
Modular workbook design – Separate sheets for raw data, calculations, assumptions, and presentation.
Error-proofing – Heavy use of IFERROR, ISNUMBER, data validation, and circular reference checks.
Audit trails – Each key formula is documented either via N() comments or a side “Documentation” column.

Collaboration & Sharing

For shared editing, use cloud-native (Google Sheets or OneDrive Excel) with clear edit permissions.
Avoid giving edit access to core logic sheets; use protected interface cells.
Use comments and cell notes to explain non-obvious logic.

The Future of Spreadsheets According to Daniel T. Li

As we look toward 2025 and beyond, many predict the death of the spreadsheet. Daniel T. Li disagrees. Spreadsheet Expertise : Daniel T

In a recent interview with TechCrunch, he stated: "Spreadsheets won't die. They will mutate. We are entering the era of the 'Smart Grid'—spreadsheets connected live to SQL databases, CRMs, and weather APIs. But the grid itself—rows, columns, formulas—remains the most democratic way for a human being to think about numbers."

He is currently working on "Project LET" —a series of spreadsheets that utilize the new Excel LET function to let users define variables inside formulas, essentially turning spreadsheets into functional programming languages without writing a single line of VBA.