ROdata_XL211_BLANK.xls

XLS spreadsheet 508 KB Posted Dec 3, 2025

Attached to: REVERSE OSMOSIS, DEGASIFICATION AND ION EXCHANGE SYSTEM SUPPORT SERVICES
Solicitation number: 2026-IFB-LM-0055
Issued by: Los Angeles County, California

About this file

Written by GovTribe AI · Mar 9, 2026

This is a reverse osmosis system monitoring and operational data log maintained by the City of Pasadena Water & Power Department for the water treatment module at the Glenarm Power Plant. The file is an Excel spreadsheet (ROdata_XL211_BLANK.xls) that serves as a technical template for recording and calculating performance metrics of the facility's reverse osmosis, degasification, and ion exchange water purification systems. The spreadsheet contains operational data fields for feed temperature, salinity, permeate flow rates, pressure readings, and chemical injection parameters, along with automated calculations for system performance indicators including salt passage percentage, system rejection rates, water transport coefficients, and normalized operational metrics. The log includes monitoring data entries dated from May 12-23, 2017, with specific instrument tag numbers for sensors including feed pH (AIT-15423), feed conductivity (CIT-15422), feed temperature (CIT-15422), reject flow (FIT-68224), first-stage feed pressure (PI-68240), product conductivity (CIT-68221), product flow (FIT-68223), and product outlet pressure (PI-68243). The template establishes operational limits and parameters essential for the facility's production of approximately eight million gallons of demineralized and deionized water annually for electric power generation.

The spreadsheet incorporates Hydranautics proprietary formulas and algorithms for calculating normalized system performance across five critical metrics: system salt passage, system permeate flow, differential pressure, water transport coefficient, and salt transport coefficient. These calculations enable facility operators to track membrane efficiency, identify performance degradation, and optimize treatment processes. The data structure accommodates daily operational logging with fields for chemical dosing (sodium bisulfate at 65 milliliters and antiscalent reagent), cartridge filter information, and comments for operational notes. The file functions as the primary technical monitoring tool referenced in the Pasadena Water & Power Department's competitive sealed bid solicitation for reverse osmosis system support services, demonstrating the facility's commitment to systematic performance tracking and data-driven maintenance decision-making for water treatment infrastructure.

View the file

Other files

File	Type	Posted
REVERSE_OSMOSIS,_DEGASIFICATION_AND_ION_EXCHANGE_SYSTEM_SUPPORT_SERVICES.pdf	PDF	Jan 29, 2026
City_of_Pasadena_IW005171_Permit.pdf	PDF	Dec 3, 2025
ROdata_XL211_BLANK.xls	XLS spreadsheet	Dec 3, 2025
Chemical_Injection_System_Drawings.pdf	PDF	Dec 3, 2025
Liqui-Cel_Membrane_Contactors_Cleaning_Guidelines.pdf	PDF	Dec 3, 2025
RO_Water_Quality_Table.docx	DOCX document	Dec 3, 2025
RO_Process_Flow_Diagram_(1).pdf	PDF	Dec 3, 2025
FAITHFUL_PERFORMANCE_BOND_FORM.pdf	PDF	Dec 3, 2025
REQUIRED_FORMS_-_AAs_-_SIG-LEGAL-STATUS_-_DECLARATION_OF_NONCOLUSION_08022024_v2.pdf	PDF	Dec 3, 2025
MATERIAL_AND_LABOR_BOND_FORM.pdf	PDF	Dec 3, 2025
Emergency_FEMA_TC.pdf	PDF	Oct 16, 2025
Subcontractor_Listing.pdf	PDF	Oct 16, 2025
Disclosure_of_Lobbying_Activities.pdf	PDF	Oct 16, 2025
MASTER_LABOR_AND_MATERIALS_CONTRACT_(12-18-24).pdf	PDF	Oct 16, 2025
Federal_Required_Certification_(4).pdf	PDF	Oct 16, 2025
DoIT_Technical_Questionnaire.xlsx	XLSX spreadsheet	Oct 16, 2025
Unique_Entity_ID_(SAM).pdf	PDF	Oct 16, 2025
RELEVANT_EXPERIENCE_FORM.pdf	PDF	Oct 16, 2025

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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	QpNDPr/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	QpoCpoTCF/264.17/60/(EPVVEMAe*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

bar to psi

psiPERbar

14.50

Perm Flow

Qpe

GPD

Constant

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

SSPn

QSPn

DPn

WTCn

STCn

Rec

Day

Cfo

Cpo

Qco

Qpo

Pfo

Pco

Ppo

ConF

Cf ave

FOP ave

POP

DPo

NDP

SFX

SSP

SSR

TCF

ASPn

ppm

gpm

psi

gpm

psi

m/s - kPa

m/s

psi

days

ppm

gpm

psi

ppm

psi

gfd

no units

Comments

01-27-2003

0.00

0.000E+00

0.00%

0.00

-17.78

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 Mar 9, 2026.