Water Quality

Ion Balance for STARTING Water Quality

Blended Waters

Source Water A

Source Water B

Source Water C

Blended Water Quality

Modeled TOC Removal

Required water quality parameters:

1) pH

2) Alkalinity

3) Temperature

4) DOC

5) UV254 Absorbance

Chemical Addition





                              

                              

                                

                              

                            

                          

                        

                      

                    

                  

                

                

                  

                  

                    

                      

                        
Set Water Quality Targets

                      

                      

                        

                          

                            
                            

                              

                                

                                  

                                    

                                      
                                      
                                    

                                    

                                      
                                      
                                    

                                  

                                  

                                    
                                  

                                  

                                    
                                    

                                    

                                    
                                  

                                

                              

                              

                                

                                  

                                    

                                      
                                      
                                    

                                    

                                      
                                      
                                    

                                  

                                  

                                    
                                  

                                  

                                    
                                    

                                    

                                    
                                  

                                

                              

                            

                          

                        

                      

                    

                  

                

              

            

          

          

            

              

                

                  

                    

                      

                        
Toggle Inputs

                      

                      

                        

                          

                            
                            

                              

                                
Required inputs:

                                
1) DOC

                                
2) PAC dose (model only takes up to 30 mg/L)

                                
3) Contact Time

                                
4) PAC type

                              

                            

                            
                          

                        

                        

                          
                          
                        

                        

                          
                          
                        

                        
                        

                          
                          
                        

                      

                    

                  

                  

                  

                  

                  

                    

                      

                        
Chemicals Dosed

                      

                      

                        

                      

                    

                  

                

                

                  

                    

                      

                        
Modeled DOC Removal using PAC

                      

                      

                        
                      

                    

                  

                

              

            

          

          

            

              

                

                  

                    

                      

                        

                          
Toggle Inputs

                        

                        

                          

                            

                              
                              

                                

                                  
Required inputs for all models:

                                  
1) pH

                                  
2) Alkalinity

                                  
3) Temperature

                                  
4) DOC

                                  
5) UV254

                                  
6) Bromide

                                  
7) Ozone contact time

                                  
8) Ozone dose

                                  Additional input required for ozone CT: 
                                  
1) Baffle factor

                                  
2) Decay constant, kd

                                   Additional input required for bromate formation: 
                                  
1) Ammonia (depending on selected model)

                                

                              

                              
                            

                          

                          

                            

                              
                              
                            

                            

                              
                              
                            

                          

                          

                            

                              
                              
                            

                            

                              

                                
                                
                              

                            

                            

                              

                                
                                
                              

                            

                          

                        

                      

                    

                    

                      

                    

                    

                      

                      

                      

                      

                    

                    

                      

                    

                  

                  

                    

                      

                        
Chemical Addition

                      

                      

                        

                          
                        

                        

                        

                        

                        

                          

                            
                            

                              

                                

                              

                              

                                

                              

                            

                          

                        

                      

                    

                  

                

                

                  

                    

                      
                      

                        

                          
                        

                        

                          
                        

                        

                          
                        

                      

                    

                  

                

              

            

          

          

            

              

                

                  

                    

                      

                        

                          
                            Toggle Inputs
                            
                          
                        

                      

                      

                        
                        

                          

                            
                            

                              

                                
Required model inputs

                                Inputs for DBP formation: 
                                
1) pH

                                
2) Temperature

                                
3) DOC

                                
4) UV254

                                
5) Bromide

                                
6) Chlorine type

                                
7) Chlorine dose

                                
8) Chlorine contact time

                                
9) Treatment - chlorine dosed into raw, coagulated or post-GAC water

                                Inputs for chlorine CT: 
                                
1) pH

                                
2) Temperature

                                
3) Chlorine contact time

                                
4) Chlorine residual

                                
5) Baffle factor

                              

                            

                            
                          

                        

                        

                          
DBP Formation

                          

                            
                            
                          

                          

                            
                            
                          

                          

                            
                            
                          

                          
                          

                            
                            
                          

                        

                        

                          
CT Calculation

                          

                            
                            
                          

                          

                            
                            
                          

                          

                            
                            
                          

                        

                      

                    

                  

                  

                    

                      

                        

                          
Water Quality Post-Disinfection

                        

                        

                          
                        

                      

                    

                    

                    

                    

                    

                  

                

                

                  

                    

                      
                      

                        

                          
                        

                        

                          

                            

                              
                            

                          

                          

                          
                        

                      

                    

                  

                  

                    

                      

                        
Concentration x Time (CT)

                      

                      

                        
                      

                    

                  

                

              

            

          

          

            

              

                

                  

                    

                      

                        

                          
                            Scaling Indices
                            
                          
                        

                      

                      

                        

                          

                            
                            

                              

                                
Required model inputs

                                Langelier Saturation Index
                                
1) pH

                                
2) Alkalinity

                                
3) Temperature

                                
4) Calcium

                                
5) TDS or Conductivity

                                CCPP
                                
1) pH

                                
2) Alkalinity

                                
3) Temperature

                                
4) Calcium

                                Ryznar Stability Index
                                
1) pH

                                
2) Alkalinity

                                
3) Temperature

                                
4) Calcium

                                
5) TDS or Conductivity

                              

                            

                            
                          

                        

                        
                        
                        

                        

                        
                        

                        

                        
                      

                    

                  

                  

                    

                      

                        

                          
                            Corrosion Indices
                            
                          
                        

                      

                      

                        

                          

                            
                            

                              

                                
Required model inputs

                                Larson Skold Index
                                
1) Alkalinity

                                
2) Chloride

                                
3) Sulfate

                                CSMR
                                
1) Chloride

                                
2) Sulfate

                                Aggressiveness Index
                                
1) pH

                                
2) Alkalinity

                                
3) Calcium

                              

                            

                            
                          

                        

                        
                        
                        

                        

                        
                        

                        

                        
                      

                    

                  

                  

                    

                      

                        
Dissolved Lead

                      

                      

                        

                          

                            
                            

                              

                                
Required model inputs

                                Lead solubility
                                
1) pH

                                
2) Alkalinity

                                
3) TDS or Conductivity

                              

                            

                            
                          

                        

                        

                          

                            
                            

                              

                                

                                  

                                    
                                  

                                  

                                    

                                  

                                

                                
                              

                            

                          

                        

                      

                    

                  

                

                

                  

                    

                      

                        
Set Water Quality Targets

                      

                      

                        

                          

                            
                            

                              

                                

                                  

                                    

                                      
                                      
                                    

                                    

                                      
                                      
                                    

                                  

                                  

                                    
                                  

                                  

                                    
                                    

                                    

                                    
                                  

                                

                              

                              

                                

                                  

                                    

                                      
                                      
                                    

                                    

                                      
                                      
                                    

                                  

                                  

                                    
                                  

                                  

                                    
                                    

                                    

                                    
                                  

                                

                              

                            

                          

                        

                      

                    

                  

                  

                    

                      

                        
Current Water Quality

                      

                      

                        
                      

                    

                  

                

              

            

          

          

            

              

                

                  

                    

                      

                        
Chemical Costs

                      

                      

                        

                          

                            
Chemical Dose

                            

                            

                          

                          

                            
Chemical Strength (%)

                            

                            

                          

                          

                            
Chemical Cost ($/lb)

                            

                            

                          

                        

                        

                          

                          

                          
                        

                      

                    

                  

                  

                    

                      

                        
Labor Costs

                      

                      

                        

                          
                          
                        

                        

                          
                          
                        

                        

                        

                      

                    

                  

                

                

                  

                    

                      

                        

                          
Plant Flow

                        

                        

                          

                            
                            
                          

                        

                      

                    

                    

                      

                        

                          
Solids Disposal Costs

                        

                        

                          

                            
                            
                          

                          

                            
                            
                          

                          

                        

                      

                    

                  

                  

                    

                      

                        
Power Costs

                      

                      

                        

                          
Instructions:

                          
1) Right click on table's WHITE cells to add more rows.

                          
2) Double click on a cell to assign power usage to each added item.

                          
3) Do not alter column names.

                          

                        

                        

                          

                            
                            
                          

                          

                        

                      

                    

                  

                  

                    

                      

                        
Total Costs