This report evaluates the current common practices for wastewater treatment plant (WWTP) design calculations using Microsoft Excel. It identifies critical gaps in standard "ad-hoc" spreadsheet approaches—specifically regarding error rates, traceability, and version control. The report outlines a roadmap to achieve "better" calculation spreadsheets through standardization, automation (VBA), and integrated checking protocols, ultimately aiming to reduce engineering man-hours and mitigate technical risk.
A common mistake in engineering spreadsheets is mixing inputs, calculations, and outputs on the same lines. A better spreadsheet separates these distinct zones.
: Volume calculations based on Biological Oxygen Demand (BOD) loading and desired sludge age. Settling Tanks
Post A Comment