P calcs
PHOSPHORUS REMOVAL CALCULATIONS Will Flack | Updated 5/11/25 Normally delete info in yellow cells, apart from FE per Capita, PST M/T and returning to pre-entered values. Note: There are tabs before the front sheet — don't miss them. Replace Elmswell crude spots data with the actual works data. General Notes • Crude Sheet / Spots Sheet: RHS calculates in loads • "mg/l" units are wrong — change to kg/d • Composites Sheet: correct as-is FE Composite Sampling Data • Used for cloth filter sizing • If taking a lagoon out of service, use HST effluent data here instead • Ensure the summary covers the full data range • A PE-based load may be used instead of sampling data TSFR • Copy data to a separate document, remove errors, then paste back — add a link to the original data • Adjust print area to show graphs, not pages of raw data • Instantaneous Flows: Select the highest 12-month period and confirm it matches the sample date so loads calculate correctly • Set a sensible print ...