Daniel T Li Spreadsheets Better |best| Jun 2026

: Always explicitly state units and number formats to prevent catastrophic input errors.

Instead of building a spreadsheet from scratch, which involves developing formulas and validating them, engineers can use pre-built templates. These include specialized analyses like: (using FEM methods). Column Deformation Compatibility Design . Flexible Diaphragm with Opening Analysis . Handrail Design (AISC 360/ACI 318). 3. Clear Input/Output Structures

The invisible engine of the workbook. This is where complex formulas, lookups, and data transformations happen behind the scenes. daniel t li spreadsheets better

Many engineers create their own spreadsheets, which can lead to: Using outdated files. Hidden Errors: Undetected formula errors.

Modern businesses frequently fall into the trap of buying a new software subscription for every problem they encounter. Li points out several hidden costs and friction points associated with this "app sprawl": : Always explicitly state units and number formats

are you currently designing (e.g., steel, concrete, timber)? What specific code are you working under?

If you're looking for a draft—whether it's a social media post, a blog intro, or a guide—here are a few ways we can frame it: Option 1: The "Clean Structure" Angle (Short & Punchy) Column Deformation Compatibility Design

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

Fixing these issues requires a shift in mindset. A spreadsheet should not be treated as a digital piece of scratch paper. Instead, it should be treated as a software application.