ROdata_XL211_BLANK.xls
XLS spreadsheet 508 KB Posted
- Solicitation number
- 2026-IFB-LM-0055
- Issued by
- Los Angeles County, California
About this file
This is an operational data log and monitoring template for the City of Pasadena Water and Power Department's reverse osmosis water treatment system located at the Glenarm Power Plant in Pasadena, California. The spreadsheet contains technical formulas and calculation parameters for tracking reverse osmosis system performance, including normalized data calculations for system salt passage, permeate flow, differential pressure, water transport coefficients, and salt transport coefficients. The file includes a blank data entry template dated January 27, 2003, and an actual operational monitoring log covering the period from May 12, 2017 through May 23, 2017, documenting daily measurements of feed temperature, feed salinity, permeate salinity, concentrate flow, permeate flow, system pressures, product conductivity, product flow, and product outlet pressure. The system is designed to produce approximately 8 million gallons of demineralized and deionized water annually for electric power generation, with monitoring conducted across multiple stages including pre-treatment cartridge filters, reverse osmosis skids with dual stages, and polishing equipment. Operational limits and specifications are established for chemical dosing (sodium bisulfate antiscalent at 65 milliliters), feed pH range (7.5-9.0), product flow capacity (75-230 gallons per minute), and system pressures monitored at feed, reject, and product outlet points.
The file serves as a technical reference document and operational record for bidders responding to the City's solicitation for Reverse Osmosis, Degasification and Ion Exchange System Support Services, providing detailed specification data about the existing infrastructure, equipment performance expectations, and historical monitoring parameters that potential vendors must understand to effectively support system maintenance and operation.
View the file
Other files
Show all 18
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
HelpFile
| Data Calculations | Symbol | Units | ROdataXL |
| Recovery | Rec | no units | Qp / (Qp + Qc) |
| Concentration Factor | ConF | no units | ln(1/(1-rec))/rec |
| Average Feed Salinity(log mean average) | Cf ave | ppm | Cfo * ConF |
| Pressure Drop (Delta P) | DPo | psi | Pf - Pc |
| Average Feed Osmotic Pressure | FOP ave | psi | Cf_ave *11.8* (273 + To)/(298*1000) |
| Permeate Osmotic Pressure | POP | psi | Cpo *11.8* (273 + To)/(298*1000) |
| Net Driving Pressure | NDP | psi | Pfo - (0.5 * DPo) - Ppo - FOP_ave + POP |
| System Salt Passage | SSP | % | 100 * Cpo/Cf_ave |
| System Rejection | SSR | % | 100 - SSP |
| System Flux (average) | SFX | gfd | 1440 * Qpo / (EPV * V * EMAe) |
| Temperature Correction Factor | TCFo | no units | EXP(Ke*(1/(273+To)-(1/298))) |
| Normalized Data Calculations | |||
| Normalized System Salt Passage | SSPn | % | SSP*(Qp/Qpr)*(TCF/TCFr) |
| Normalized System Permeate Flow | QSPn | gpm orm³/hr | Qp*NDPr/NDP*(TCF/TCFr) |
| Normalized Delta P (pressure drop) | DPn | psi or bar | DP * (Qpr / 2 +Qcr ) ^ 1.4 / ((Qp / 2 + Qc)) ^ 1.4 |
| Water Transport Coefficient (Normalized) | WTCn | m/sec-kPa | 0.00000006849 * SFX/NDP*TCF |
| Salt Transport Coefficient (Normalized) | STCn | m/sec | Qpo*Cpo*TCF/264.17/60/(EPV*V*EMAe*0.0929)/(Cf_ave - Cpo) |
| Parameters(Logged Field Data)) | Units forCalculation | Operational DataSymbol | |
| Feed Temperature | °C | To | |
| Feed Salinity | ppm | Cfo | |
| Permeate Salinity | ppm | Cpo | |
| Concentrate Flow | gpm or m³/hr | Qco | |
| Permeate Flow | gpm or m³/hr | Qpo | |
| Feed Pressure | psi or bar | Pfo | |
| Concentrate Pressure | psi or bar | Pco | |
| Permeate Pressure | psi or bar | Ppo | |
| Conversion factors | |||
| 'psi/kPa = 0.145 | |||
| 'm3/gal = 3.785E-3 | |||
| 'ft2/m2 = 10.7639 | |||
| 'day/sec = 1.1574e-5 |
Data
| Train | Standard Test Conditions | System | Conversion Factors | ||||||||||||||||||||||||||||||||||||
| Element | Perm Flux | EFX | gfd | Elements/Vessel | EPV | m3/h to gpm | gpmPERm3h | 4.40 | |||||||||||||||||||||||||||||||
| Charts: | Area | EMAe | sq ft | Vessels | V | bar to psi | psiPERbar | 14.50 | |||||||||||||||||||||||||||||||
| Perm Flow | Qpe | GPD | |||||||||||||||||||||||||||||||||||||
| Constant | Ke | no units | |||||||||||||||||||||||||||||||||||||
| Net Drive Pressure | NDPe | PSI | |||||||||||||||||||||||||||||||||||||
| Concentration - feed | Cfe | ppm | |||||||||||||||||||||||||||||||||||||
| Version 2.11 | |||||||||||||||||||||||||||||||||||||||
| Concentration | Flows | Pressures | Normalized Data | Calculated Data | |||||||||||||||||||||||||||||||||||
| Feed | Perm | Con | Perm | Feed | Con | Perm | Salt Passage | Perm Flow | Differential Pres. | Water Transport Coeficient | Salt Transport Coeficient | ||||||||||||||||||||||||||||
| Date | Hour | Operator | pH | T | Cf | Cp | Qc | Qp | Pf | Pc | Pp | SSPn | QSPn | DPn | WTCn | STCn | Rec | DP | Day | To | Cfo | Cpo | Qco | Qpo | Pfo | Pco | Ppo | ConF | Cf ave | FOP ave | POP | DPo | NDP | SFX | SSP | SSR | TCF | ASPn | |
| F | ppm | ppm | gpm | gpm | psi | psi | psi | % | gpm | psi | m/s - kPa | m/s | % | psi | days | C | ppm | ppm | gpm | gpm | psi | psi | psi | ppm | ppm | psi | psi | psi | psi | gfd | % | % | no units | % | Comments | ||||
| 01-27-2003 | 0.00 | 0.00 | 0.00 | 0.000E+00 | 0.000E+00 | 0.00% | 0.00 | 0.00 | -17.78 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | ||||||||||||
| InsertRow |
Hydranautics:
System Salt Passage (normalized) Hydranautics:
System Permeate Flow (normalized) Hydranautics:
Differential Pressure (normalized) Hydranautics:
Water Transport Coefficient (normalized) Hydranautics:
Salt Transport Coefficient (normalized)
Sheet1
| PASADENA WATER AND POWER WATER TREATMENT MODULE LOG | |||||||||||||
| DATE/TIME | 5/12/17 | 5/13/17 | 5/14/17 | 5/15/17 | 5/16/17 | 5/17/17 | 5/18/17 | 5/19/17 | 5/20/17 | 5/21/17 | 5/22/17 | 5/23/17 | LIMITS |
| CHEMICAL PUMPS | |||||||||||||
| SODIUM BISULFATE | |||||||||||||
| ANTISCALENT (ml) | 65 ml | ||||||||||||
| ANTISCALENT REAGENT TEST | |||||||||||||
| CARTRIDGE FILTERS | |||||||||||||
| FEED PH AIT-15423 | |||||||||||||
| FEED COND. CIT-15422 | |||||||||||||
| FEED TEMP. CIT-15422 | |||||||||||||
| FEED ORP | |||||||||||||
| R.O. SKID | |||||||||||||
| REJECT FLOW (gpm) FIT-68224 | |||||||||||||
| 1st STAGE FEED (psi) PI-682401ST | |||||||||||||
| 2ND STAGE REJECT (psi) PI-68240 | 7.5-9 | ||||||||||||
| PROD. COND. (mS/cm) CIT-68221 | |||||||||||||
| PROD. FLOW (gpm) FIT-68223 | 75gpm | ||||||||||||
| PRODUCT OUTLET (psi) PI-68243 | 230gpm | ||||||||||||
| POLISHER RESISTIVITY | |||||||||||||
| LEAD (B) | <10µS | ||||||||||||
| LAG (A) | <10µS | ||||||||||||
| MULTI MEDIA FILTERS | |||||||||||||
| A THRUPUT (kgal) | |||||||||||||
| B THRUPUT (kgal) | |||||||||||||
| NEW POLISHERS REPLACED | |||||||||||||
| DATE/TIME | 5/24/17 | 5/25/17 | 5/26/17 | 5/27/17 | 5/28/17 | 5/29/17 | 5/30/17 | 5/31/17 | 6/1/17 | 6/2/17 | 6/3/17 | 6/4/17 | LIMITS |
| CHEMICAL PUMPS | |||||||||||||
| SODIUM BISULFATE | |||||||||||||
| ANTISCALENT (ml) | 65 ml | ||||||||||||
| ANTISCALENT REAGENT TEST | |||||||||||||
| CARTRIDGE FILTERS | |||||||||||||
| FEED PH AIT-15423 | |||||||||||||
| FEED COND. CIT-15422 | |||||||||||||
| FEED TEMP. CIT-15422 | |||||||||||||
| FEED ORP | |||||||||||||
| R.O. SKID | |||||||||||||
| REJECT FLOW (gpm) FIT-68224 | |||||||||||||
| 1st STAGE FEED (psi) PI-682401ST | |||||||||||||
| 2ND STAGE REJECT (psi) PI-68240 | 7.5-9 | ||||||||||||
| PROD. COND. (mS/cm) CIT-68221 | |||||||||||||
| PROD. FLOW (gpm) FIT-68223 | 75gpm | ||||||||||||
| PRODUCT OUTLET (psi) PI-68243 | 230gpm | ||||||||||||
| POLISHER RESISTIVITY | |||||||||||||
| LEAD (B) | <10µS | ||||||||||||
| LAG (A) | <10µS | ||||||||||||
| MULTI MEDIA FILTERS | |||||||||||||
| A THRUPUT (kgal) | |||||||||||||
| B THRUPUT (kgal) | |||||||||||||
| NEW POLISHERS REPLACED |
Element Info
| Element information must begin at row 10 | ||||||||
| Element | Area | Feed Con | Flow | Rej | TCF | NDP | Diameter | Length |
| ft 2 | TDS | GPD | % | psi | in | in | ||
| CPA2-4040 | 85 | 1500 | 2250 | 99.2 | 2700 | 206 | 4 | 40 |
| CPA2 | 365 | 1500 | 10000 | 99.5 | 2700 | 206 | 8 | 40 |
| CPA2-8540 | 445 | 1500 | 12000 | 99.5 | 2700 | 206 | 8.5 | 40 |
| CPA3 | 400 | 1500 | 11000 | 99.6 | 2700 | 206 | 8 | 40 |
| CPA4 | 400 | 1500 | 6000 | 99.7 | 2700 | 206 | 8 | 40 |
| LFC1-4040 | 85 | 1500 | 2300 | 99.5 | 2700 | 206 | 4 | 40 |
| LFC1 | 400 | 1500 | 10000 | 99.5 | 2700 | 206 | 8 | 40 |
| LFC2-4040 | 85 | 1500 | 2500 | 95 | 2700 | 206 | 4 | 40 |
| LFC2 | 365 | 1500 | 11000 | 95 | 2700 | 206 | 8 | 40 |
| LFC3-4040 | 85 | 1500 | 2000 | 99.6 | 2700 | 206 | 4 | 40 |
| LFC3 | 400 | 1500 | 9500 | 88.6 | 2700 | 206 | 8 | 40 |
| ESPA1-4040 | 85 | 1500 | 2600 | 99 | 2700 | 125 | 4 | 40 |
| ESPA1 | 400 | 1500 | 12000 | 99 | 2700 | 125 | 8 | 40 |
| ESPA2-4040 | 85 | 1500 | 1900 | 99.5 | 2700 | 125 | 4 | 40 |
| ESPA2 | 400 | 1500 | 9000 | 99.5 | 2700 | 125 | 8 | 40 |
| ESPA3-4040 | 85 | 1500 | 3000 | 98 | 2700 | 125 | 4 | 40 |
| ESPA3 | 400 | 1500 | 15000 | 98 | 2700 | 125 | 8 | 40 |
| ESPA4-4040 | 85 | 500 | 2500 | 99.2 | 2700 | 90 | 8 | 40 |
| ESPA4 | 400 | 500 | 12000 | 99.2 | 2700 | 90 | 8 | 40 |
| ESNA1-4040 | 85 | 500 | 2300 | 80 | 2700 | 68 | 4 | 40 |
| ESNA1 | 400 | 500 | 11000 | 80 | 2700 | 68 | 8 | 40 |
| ESNA1-8540 | 445 | 500 | 12000 | 80 | 2700 | 68 | 8.5 | 40 |
| ESNA1-LF | 400 | 500 | 7500 | 86 | 2700 | 68 | 8 | 40 |
| ESNA1-LF-4040 | 85 | 500 | 1600 | 86 | 2700 | 68 | 4 | 40 |
| ESNA2 | 400 | 500 | 15000 | 60 | 2700 | 68 | 8 | 40 |
| HYDRACoRe | 365 | 500 | 8200 | 50.0 | 2700 | 68 | 8 | 40 |
| SWC1-4040 | 70 | 32000 | 1100 | 99.6 | 2700 | 413.5 | 4 | 40 |
| SWC1 | 315 | 32000 | 5000 | 99.7 | 2700 | 413.5 | 8 | 40 |
| SWC2-4040 | 70 | 32000 | 1400 | 99.2 | 2700 | 413.5 | 4 | 40 |
| SWC2 | 315 | 32000 | 6200 | 99.2 | 2700 | 413.5 | 8 | 40 |
| SWC3 | 370 | 32000 | 5900 | 99.7 | 2700 | 413.5 | 8 | 40 |
| SWC4 | 370 | 32000 | 5500 | 99.8 | 2700 | 413.5 | 8 | 40 |
Language
| When new language is added: | |||
| 1. Update the dropdown box on the frmSetup with the new language | |||
| 2. Update the subroutine "MainLabelSetup" | |||
| First Time | |||
| LangUnits | 0 | ||
| 0 | 1 | 2 | |
| English | Spanish | Portuguese | |
| Project Name | Projecto | Nome do Projeto | |
| Train | Banco | Banco | |
| Date | Fecha | Data | |
| Hour | Hora | Hora | |
| Feed pH | pH Alim. | pH Alim. | |
| Feed Temp | Temp. Alim. | Temp. Alim. | |
| Feed Salinity | Salinidad Alim. | Salinidade Alim. | |
| Perm Salinity | Salinidad Perm. | Salinidade Perm. | |
| Conc Flow | Flujo Conc. | Fluxo Concentrado | |
| Perm Flow | Flujo Permeado | Fluxo Permeado | |
| Feed Pressure | Presión Alim. | Pressão Alim. | |
| Conc Pressure | Presión Conc. | Pressão Conc. | |
| Perm Back Pres | Contrapresión Perm. | Contrapressão Perm. | |
| Element Selection | Selección Elemento | Escolha da Membrana | |
| Elements / vessel | Elementos /tubo | Elementos / Vaso | |
| Vessels | Tubos | Vasos | |
| Standard Test Conditions | Condiciones de Prueba Estándar | Condições de Teste | |
| Area (sq. ft.) | Area (p²) | Área (ft 2) | |
| Feed TDS (ppm) | SDT Alim. | Alim. TDS (ppm) | |
| Flow (gpd) | Flujo (gpd) | Fluxo (gpd) | |
| Rej (%) | Rechazo (%) | Rejeição | |
| TCF | FCT | TCF | |
| NDP (psi) | PNA (psi) | NDP (psi) | |
| Operator | Operador | Operador | |
| Comments | Observaciones | Comentários | |
| Add Data | Introduzca Datos | Adicionar Dados | |
| Operation Data | Datos de Operación | Dados Operacionais | |
| Reference Data | Datos de Referencia | Dados de Referência | |
| Concentration | Concentración | Concentração | |
| Flows | Flujos | Fluxos | |
| Pressures | Presiones | Pressões | |
| Calculated Data | Datos Calculados | Dados Calculados | |
| Normalized Data | Datos Normalizados | Dados Normalizados | |
| Feed | Alim | Alim. | |
| Salt Passage | Passagem de Sal | Passagem de Sal | |
| Perm Flow | Flujo de Permeado | Fluxo de Permeado | |
| Differential Pres. | Diferencial de Presión | Diferencial de Pressão | |
| Water Transport Coeficient | Coef. Transp. Água | Coef. Transp. Água | |
| Salt Transport Coeficient | Coef. Transp. Sal | Coef. Transp. Sal |
Perm Flow
Train Qp Day gpm Perm Flow
Feed Pres
Train Qp Day psi Feed Pressure
Perm Con.
Train Qp Day ppm Permeate Concentration
Salt Passage (Norm)
Train Normalized Data Qp Day Salt Passage
Perm Flow (Norm)
Train Normalized Data Qp Day gpm Perm Flow
Differential Pres (Norm)
Train Normalized Data Qp Day psi Differential Pres.
Water Trans. Coefficient
Train Qp Day m/s - kPa Water Transport Coeficient
Salt Trans. Coefficient
Train Qp Day m/s Salt Transport Coeficient
File details come from the government source that posted it. Updated .