Daniel T Li Spreadsheets -

…I can locate the exact paper or explain its contents regarding spreadsheets.

Unlike modern "black box" software, where you input data and receive an answer without understanding the intermediate steps, Daniel T. Li’s spreadsheets were educational as well as functional. They forced the user to engage with the underlying mathematics, fostering a deeper understanding of the physical phenomena being modeled.

The suite is organized into groups based on engineering disciplines and materials, including: daniel t li spreadsheets

While his chemical engineering tools are perhaps his most cited work, the "Daniel T. Li spreadsheets" collection covered a surprisingly broad spectrum of technical disciplines.

His "Steam Table" spreadsheets allowed engineers to input pressure and temperature and instantly receive thermodynamic properties. But the true genius lay in the interpolation. Mathematical interpolation—estimating values between known data points—is tedious and prone to human error. Li automated this process, saving countless hours of manual calculation for students and professional engineers alike. …I can locate the exact paper or explain

The primary appeal of these spreadsheets lies in their practical, engineer-focused design. Unlike generic calculators, they are tailored for submittals and professional review.

Avoid "clumping" data. For example, keep First Name and Last Name in separate columns. Be Consistent: They forced the user to engage with the

In the pre-Google era, an engineer needing to calculate the enthalpy of superheated steam or the specific volume of a gas mixture would have to leaf through dense reference books like Perry’s Chemical Engineers' Handbook or Keenan & Keyes. Li transformed these static tables into dynamic computational engines.

(e.g., from MIT, Harvard, or a finance journal) where spreadsheets are used as a tool — for example, in case studies on option pricing , portfolio construction , or Monte Carlo simulation in Excel.

By locking cells, the author ensures that users do not accidentally corrupt complex formulas that could lead to structural errors.