Laserfiche WebLink
)4NALco <br /> NCPA Lodi <br /> Process Model-Table of Contents <br /> General Notes: <br /> 1. Cells colored green contain formulas-do not change unless you're sure. <br /> 2. Cells colored yellow require entry. <br /> 3. Cell Range A1:H27 MUST remain the same for all sheets <br /> This workbook contains the following spreadsheets: <br /> Spreadsheet Purpose <br /> Contents Lists contents of this workbook <br /> Cost History Module History of capital costs for major equipment from bids. <br /> Dispatch Summary Calculates average system throughput based on plant dispatch schedule. <br /> Cost Data Entry Module Spreadsheet for entering general cost information. <br /> Parameter Data Entry Module Spreadsheet for entering critical control parameters for equipment. <br /> Cost Summary Module Summarizes O&M and Capital Cost estimates. <br /> Raw Water Module Calculates combined water quality based on a mix of up to three separate water sources. <br /> Calculates combined influent water quality based on a mix of up to three separate water sources. Uses combined influent <br /> water quality and user-entered values to calculate softened effluent water quality assuming precipitation softening. <br /> Lime Soda Softener Module Calculates sludge volumes and chemical feeds using either caustic/soda or lime/soda chemistry. <br /> Acid Feed Module Calculates acid feed(sulfuric or hydrochloric)required to reduce Lime Soda Softener effluent pH to a user entered value. <br /> Gravity and Micro Filters Calculates backwash and other flows and costs associated with MMF operation. <br /> Cooling Tower Module Uses combined influent water quality and user-entered values to calculate cycled water chemistry. <br /> Makeup RO Acid Feed Module Calculates acid feed(sulfuric or hydrochloric)required to reduce makeup RO influent pH to a user entered value. <br /> 1St Pass RO Accepts up to three influent water sources. Calculates permeate and reject water qualities and quantities. <br /> Uses combined influent water quality and user-entered values to calculate effluent water quality,regenerant influent water <br /> Hydrogen SAC IX Module quality,and regenerant effluent water quality. Assumes the use of Strong Acid Cation resin. <br /> Uses combined influent water quality and user-entered values to calculate sodium-softened effluent water quality, <br /> Sodium SAC IX Module regenerant influent water quality,and regenerant effluent water quality. Assumes the use of Strong Acid Cation resin. <br /> Uses combined influent water quality and user-entered values to calculate softened effluent water quality assuming <br /> regeneration with acid,regenerant influent water quality,and regenerant effluent water quality. Assumes the use of Weak <br /> Hydrogen WAC IX Module Acid Cation resin. <br /> Uses combined influent water quality and user-entered values to calculate softened effluent water quality assuming <br /> regeneration with acid followed by regeneration with caustic(to convert resin from the H+form to the Na+form). Also <br /> Sodium WAC IX Module calculates regenerant influent water quality,and regenerant effluent water quality. <br /> Uses combined influent water quality and user-entered values to calculate acid feed required to remove alkalinity. Allows <br /> MU Degas/Acid Feed Module use of either hydrochloric or sulfuric acid for pH adjustment. <br /> Uses combined influent water quality and user-entered values to calculate effluent water quality,regenerant influent water <br /> SBA IX Module quality,and regenerant effluent water quality. Assumes the use of Strong Base Anion resin. <br /> Uses combined influent water quality and user-entered values to calculate effluent water quality,regenerant influent water <br /> Polishing Mixed Bed IX Module quality,and regenerant effluent water quality. Assumes the use of Mixed Bed IX resin. <br /> Uses combined influent water quality and user-entered values to calculate effluent water quality. Assumes the use of Mixed <br /> Offsite Polishing Mixed Bed IX Module Bed IX resin regenerated offsite by others. <br /> Calculates combined influent water quality based on a mix of up to three separate water sources. Uses combined influent <br /> water quality and user-entered values to calculate acid feed required to remove alkalinity from the feedwater to the WWRO. <br /> WWRO Degas/Acid Feed Module Allows use of either hydrochloric or sulfuric acid for pH adjustment. <br /> Calculates combined influent water quality based on a mix of up to three separate water sources. Uses combined influent <br /> water quality and user-entered values to calculate acid feed required caustic feed to stabilize silica prior to feed to the <br /> WWRO Caustic Feed Module WWRO. <br /> Side Stream RO Accepts up to three influent water sources. Calculates permeate and reject water qualities and quantities. <br /> Side Stream RO Filter Calculates backwash and other flows and costs associated with MMF operation. <br /> Uses combined influent water quality and user-entered values to calculate acid feed required to remove alkalinity from the <br /> Evaporator Acid Feed Module feedwater to the Brine Concentrator. Allows use of either hydrochloric or sulfuric acid for pH adjustment. <br /> Accepts up to three influent water sources. Calculates combined influent feedwater,BC distillate,and BC blowdown water <br /> Evaporator chemistry and quanities. <br /> Accepts up to three influent water sources. Calculates combined influent feedwater and distillate water chemistry and <br /> Crystallizer Module quanities. Also calculates volume and quality of sludge produced. <br /> Accepts up to three influent water sources. Calculates combined influent feedwater chemistry and quanity. Also calculates <br /> Evaporation Pond Module volume and quality of sludge produced. <br /> Revisons List of revisions to this document <br /> File:Copy of NCPA Lodi Water Balance Lime—MgO 15 COC Rev A 070708.xis Sheet:Contents Page 1 of 1 Date:9/2/2008 <br />