Daniel T Li Spreadsheets ⭐ Recent

Dynamically pulls entire chunks of data matching specific criteria into a new view without altering the source table.

I need to gather more details about the spreadsheets. The Google Groups post mentions that the spreadsheets are based on different codes and standards. It also mentions that the professional version is available for purchase. Let's search for "Engineering International spreadsheet list" or "Daniel T. Li spreadsheet list". couldn't find a direct list. The Google Groups post mentions "a collection of Excel spreadsheets for various design tasks based on different codes and standards". It also mentions "ASDIP Structural Software", "Structural Engineering Library (SEL)", and "CivilWeb Spreadsheets" as alternatives. This might be useful.

The Comprehensive Guide to Daniel T. Li Structural Design Spreadsheets: Engineering Excellence daniel t li spreadsheets

: DTL uses passwords to protect his intellectual property and to ensure the reliability of the formulas, preventing unauthorized modifications that could lead to engineering errors.

(The "Pretty" sheet)

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

: The collection includes comprehensive calculators for concrete design (slabs, columns, shear walls), steel design (purlins, tube columns), and lateral analysis (wind and seismic loads based on ASCE 7 and IBC codes). Dynamically pulls entire chunks of data matching specific

Pivot Tables are standard, but Li’s approach involves setting them up to refresh dynamically. By structuring source data in a (in Excel) or using Query functions, the Pivot Tables can automatically include new data as it is added. Formula Mastery: Array Formulas and LET

is a California-based Structural Engineer known in the engineering community for developing an extensive library of specialized design spreadsheets. Unlike many commercial software vendors, Li focused on creating practical, code-compliant Excel-based tools designed to solve specific, routine structural problems quickly. It also mentions that the professional version is

: Provides step-by-step sizing for ordinary and special concrete shear walls subject to combined axial and bending forces.

The primary value of the Daniel T. Li toolkit rests in its exhaustive breadth of coverage. Instead of forcing engineers to build complex, formula-heavy calculations from scratch, the Engineering International ecosystem provides pre-verified modules that rigidly adhere to United States building codes (such as ASCE 7, ACI 318, AISC 360, and the IBC). The software suite breaks down into four essential civil engineering categories: