Daniel T Li - Spreadsheets [best]
are a widely recognized suite of Microsoft Excel tools built for structural engineering professionals, providing pre-formatted formulas, references to building codes, and automated design documentation. Developed by Daniel Tian Li, Ph.D., S.E. , and distributed via Engineering International Inc., this package of nearly 500 specialized structural templates helps engineering firms calculate lateral forces, analyze foundations, and verify compliance with strict building codes. For small to mid-sized engineering offices, these spreadsheets serve as a cost-effective bridge between time-consuming manual calculations and complex, high-cost commercial Finite Element Method (FEM) software packages. What Are Daniel T. Li Spreadsheets?
The spreadsheets are designed to automate complex calculations required by various building codes (e.g., IBC, CBC, ASCE 7, ACI 318).
His spreadsheets are designed to take the manual labor out of repetitive, complex calculations, allowing engineers to focus on design optimization and safety. What are Daniel T. Li Spreadsheets?
The Digital Blueprint: The Legacy of Daniel T. Li’s Structural Spreadsheets daniel t li spreadsheets
According to peer reviews on engineering forums like Eng-Tips and Reddit's Structural Engineering community , firms have relied on this package for decades to expedite routine design tasks. Each sheet uses an intuitive, color-coded structure:
This instantly flags the exact rows where a transaction is unbalanced. No more manual debugging.
Daniel T. Li is a prominent structural engineer and the creator of a widely-used suite of structural design spreadsheets available through his company, Engineering International are a widely recognized suite of Microsoft Excel
: They are strictly formatted to follow specific standards, including ACI 318 for concrete, AISC 360 for steel, and AISI S100 for metal piping and risers. Automation
If historical data from previous years will never change, copy the rows and use Paste Special > Values Only to eliminate unnecessary background calculations. 🛠️ Essential Formulas Checklist
Li's core philosophy is that personal finance shouldn't be complicated. He doesn't advocate for rigid, one-size-fits-all budgets or get-rich-quick schemes. Instead, he believes the path to financial independence is through understanding core principles and building a tool that works for your unique situation. That tool is the humble spreadsheet. He doesn't advocate for rigid
Provides instant visual context without cluttering the canvas. Data Validation Restricts user input to a predefined list or date range Acts as a firewall against human data-entry mistakes.
The "Personal Finance for High Earners" course is an 11-section, 5.5-hour program designed for people who want to learn the frameworks for making intelligent financial choices. While it's tailored for high earners interested in concepts like financial independence and early retirement, the core lessons are applicable to anyone looking to build wealth. To get the most out of it, Li recommends following along in Excel or Google Sheets.
