The impact of Li's work on spreadsheets has been profound, with applications across various industries, including:
As we look toward 2025 and beyond, many predict the death of the spreadsheet. Daniel T. Li disagrees.
The spreadsheets are designed to automate complex calculations required by various building codes (e.g., IBC, CBC, ASCE 7, ACI 318). daniel t li spreadsheets
While this means users cannot modify the core calculation logic, the tools are still fully functional for inputting data, running calculations, and generating results. How to Access and Use the Spreadsheets
To understand the necessity of Li’s rigor, we must look at his most famous consulting restoration. In 2021, a mid-sized logistics firm came to Daniel T. Li. They had a single spreadsheet—unlocked, unprotected, and unverified—that was used to calculate fuel surcharges. The impact of Li's work on spreadsheets has
While Li is platform-agnostic, he has strong preferences. For those building Daniel T Li spreadsheets, he recommends:
A practicing structural engineer's perspective on using locked spreadsheets was captured in a 2007 discussion: "We have the entire suite of EI spreadsheets and use them whenever we can... They save a lot of time when they match the design scenario" . However, the same engineer also pointed out a critical limitation: "They are locked and cannot be modified so they don’t fit every application" . In 2021, a mid-sized logistics firm came to Daniel T
Here are the actionable takeaways from Daniel Li's approach to spreadsheets:
: By using standard Excel functions and macros, these tools reduce the time spent on repetitive manual calculations for lateral loads, seismic analysis, and gravity design. Major Categories of Analysis
Because of the separation, you can change a rep’s name in the data_Raw sheet, and the dashboard updates instantly without breaking a single formula.
: Each spreadsheet typically includes built-in formulas, reference code sections, and graphic drawings to illustrate the design. Interoperability