Most "spreadsheet experts" jump to VBA or Google Apps Script when a task becomes repetitive. Daniel T. Li argues that scripting is often a crutch that creates "black boxes" which future users cannot understand.
In the complex world of structural engineering, the tools you use can make the difference between a project that is profitable and one that is bogged down by manual calculation errors. While many firms rely on high-cost, specialized software, a growing number of professionals swear that for day-to-day design tasks. Developed by Daniel Tian Li, Ph.D., S.E., through Engineering International , these tools have become a staple in small-to-mid-sized design offices. Comprehensive Design Coverage daniel t li spreadsheets better
In a classic spreadsheet, if you type "Q1 Sales," that is a static string. If you change the quarter, you have to edit the cell. Li’s "better" approach treats every cell as a potential query. Most "spreadsheet experts" jump to VBA or Google
Please log in to add this binder to your shelf.
Most "spreadsheet experts" jump to VBA or Google Apps Script when a task becomes repetitive. Daniel T. Li argues that scripting is often a crutch that creates "black boxes" which future users cannot understand.
In the complex world of structural engineering, the tools you use can make the difference between a project that is profitable and one that is bogged down by manual calculation errors. While many firms rely on high-cost, specialized software, a growing number of professionals swear that for day-to-day design tasks. Developed by Daniel Tian Li, Ph.D., S.E., through Engineering International , these tools have become a staple in small-to-mid-sized design offices. Comprehensive Design Coverage
In a classic spreadsheet, if you type "Q1 Sales," that is a static string. If you change the quarter, you have to edit the cell. Li’s "better" approach treats every cell as a potential query.
