T Li Spreadsheets Better — Daniel

Each software package typically includes graphic drawings and formula references. Use these visualizations to immediately identify if the loading or geometry input matches your physical design intent. Best Practices for Spreadsheet Management

Instead of writing formulas like =SUM(A1:A100) , define A1:A100 as TotalSales . This makes formulas readable, easier to audit, and less prone to errors when adding new data.

Ensure every row and column is labeled with appropriate units (e.g., kips, psf, inches). daniel t li spreadsheets better

The firm used a 50MB Excel file. It crashed twice a day. Three analysts spent 15 hours a week reconciling inventory because the master sheet used volatile functions ( OFFSET , INDIRECT ) that recalculated every time you scrolled.

: Professional design ensures every input is entered only once, making it easier to trace errors. Separation of Concerns This makes formulas readable, easier to audit, and

Create three sheets in your workbook:

: His sheets are meticulously updated to reflect current building codes, such as ASCE 7-16 for wind and seismic analysis or ACI 318-14 for concrete. It crashed twice a day

Whether using Li’s templates or building your own "better" sheets, follow these professional standards: