Spreadsheet: 883512d1732121529-1-row-and-3-column-wise-lookup-using-index-match-function-excel-comp-eba
Sheet: Data

 | Make | Aster | Aster | Aster | Proton | Proton | BR Instrumentation | BR Instrumentation | Adept | Adept | Adept | Accord | Aster | Accord | Aster | Accord | Infinity | Infinity | Infinity
 | Product | Mag | pH | RO_Panel | RO_Panel | RO_Panel | Mag | Mag | Mag | Mag | Mag | RO_Panel | RO_Panel | RO_Panel | RO_Panel | RO_Panel | RO_Panel | RO_Panel | RO_Panel
 | Application | Water & Wastewater | Water & Wastewater | Water | Water | Water | Wastewater | Water | Water & Wastewater | Water & Wastewater | Water & Wastewater | Water | Water | Water | Water | Water | Water | Water | Water
 | Model | MAG 650 | PO650 pH | SA11/13/33 | IRO 11M/13M | IRO 33M | Full Bore | Smart EFM | 6410/6415 | 6420 | 6440 | AP 1:1/1:3/3:3 | LITE NXT | AP LED Lite | NXT11/13/33 | AP GSM 1:1/1:3/3:3 | A3 Series | A7 Series | A9 Series GSM
 | Display | 16 x 2 Alphanumeric LCD | 4 digit 7 segment LED display | 16 X 2 alphanumeric display | 16 x 2 LCD display | 16 x 2 LCD display | - | Digital | 2 line LCD | 2 line LCD | LCD | 4 line LCD | 3 digit LED display | - | 16 X 2 alphanumeric display(Dual color) | - | 7 Segment Red Display | 16x2 Alphabetical Blue / White | 16x2 Alphabetical Blue / White
 | Type | Full Bore/Insertion | Flow Through/Tank | - | - | - | Full Bore | Full Bore | Full Bore | Full Bore | Full Bore | - | - | - | - | - | - | - | -
 | [NAME] | 25 to 100NB | 20 NB/ 15 NB M | - | - | - | 15-1000 mm | DN 2 to DN 2000 | 10 to 3000 | 10 to 200 | 10 to 1000 | - | - | - | - | - | - | - | -
 | Flow Range | 0.2-10 to 07-140 m³/hr | - | - | - | - |  | 0 to 9999 m3 Per Hour | 0.06 to 247905.76 | 0.06 to 247905.76 | 0.06 to 247905.76 | - | - | - | - | - | - | - | -
 | Mounting | - | Field/ Pipe/ Panel | Wall/ Panel Mount | Panel Mount | Panel Mount | - | - | - | - | - | Wall/ Panel Mount | Panel Mount | Panel Mount | Wall/ Panel Mount | Panel Mount | Panel Mount | Panel Mount | Panel Mount
 | Relay | - | Individual high & low relay 5A@ 230V  (programmable through entire range with  set-able control delay & hyteresis) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Raw Water Pump | - | - | 2 hp 1Ø to 5 hp 3Ø |  |  | - | - | - | - | - | 3hp to 5hp | 1 hp 1Ø | 2hp | 2 hp 1Ø to 5 hp 3Ø | 3hp to 5hp | 2 HP 1 ф | 2 hp 1Ø to 3 hp 3Ø | 2 hp 1Ø to 3 hp 3Ø
 | High Pressure Pump | - | - | 3 hp 1Ø to 5 hp 3Ø |  |  | - | - | - | - | - | 3hp to 5hp | 2 hp 1Ø | 2hp | 3 hp 1Ø to 5 hp 3Ø | 3hp to 5hp | 2 HP 1 ф | 3 hp 1Ø to 5 hp 3Ø | 3 hp 1Ø to 5 hp 3Ø
 | [NAME] | ± 2 % FSD | ± 2% FSD | - | - | - | ± 2 % FSD | 0. 25% to 0. 50 % | ± 0.5%(± 0.2% Consult factory) | ±1% | ±0.5% | - | - | - | - | - | - | - | -
 | Input | - | - | 4 SWITCH INPUTS (LPS, HPS, TWT FLT & RWT LEVEL)  CONDUCTIVITY/ TDS | - | 4 SWITCH INPUTS (LPS, HPS, TWT FLT & RWT LEVEL)  CONDUCTIVITY/ Flow | - | - | - | - | - | LPS, HPS, [NAME] in TWT, RWT & Dosing Tank, Auto multi-port valve | Raw water tank level switch  Treated water tank level switch  Low pressure switch  High Pressure Switch | 6 Nos. of water level sensor | 7 SWITCH INPUTS (LPS, HPS, TWT FLT,DOSING TANK LEVEL &  RWT LEVEL, AMPV INPUTS (Rl1 & Rl2))  CONDUCTIVITY/ TDS  2 FLOW INPUT (WITH TOTALISER FOR CHANNEL ONE) | LPS, HPS, [NAME] in TWT, RWT & Dosing Tank, Auto multi-port valve | (RWT) Raw Water Tank Floaty (TWT) Treated Water Tank Floaty (LPS) Low Pressure Switch (HPS) High Pressure Switch | All Auto MPV * (RWT) Raw Water Tank Floaty (TWT) Treated Water Tank Floaty (LPS) Low Pressure Switch (HPS) High Pressure Switch | RWT) Raw Water Tank Floaty (TWT) Treated Water Tank Floaty (LPS) Low Pressure Switch (HPS) High Pressure Switch
 | Output | RS485/4-20mA | RS485/4-20mA | RWP, HPP, FLUSH SOLENOID VALVE & DOSER | - | Flush Solenoid and Dosing Pump | RS485/4-20mA | RS485/4-20mA | 4-20mA, pulse, relay | [NAME]. 4 – 20 mA | Pulse | Raw water pump, High pressure pump, Dosing pump, Flushing SV, UV. | Raw Water pump  High pressure pump  Flush Solenoid valve | Raw water pump, High pressure pump, Dosing pump | RWP, HPP, FLUSH SOLENOID VALVE  DOSER, ALARM & Pulse O/P | Raw water pump, High pressure pump, Dosing pump, Flushing SV, UV. | (RWP) Raw Water Pump (HPP) High Pressure Pump (FSV) Flushing Solenoid Valve (DP) Dosing pump | (RWP) Raw Water Pump (HPP) High Pressure Pump (FSV) Flushing Solenoid Valve (DP) Dosing pump | RWP) Raw Water Pump (HPP) High Pressure Pump (FSV) Flushing Solenoid Valve (DP) Dosing pump Auto MPV
 | Installation | Flange | In Vertical Line | - | - | - | Flange | Flange | Flange | Flange | Flange | - | - | - | - | - | - | - | -
 | Power supply | 230 VAC | 230 V A.C./110 V A.C./ 24 V D.C | - | - | - | 24 V DC / 230 V AC | 24 V DC / 230 V AC | 12-60 V DC / 80-300 V AC/DC wide supply, solar supplu | 12-60 V DC / 80-300 V AC/DC wide supply, solar supplu | Battery powered (5 years’ battery life) | - | - | - | - | - | - | - | -
 | Pressure rating (kg/cm2) | 10 kg/cm2 | 5 Kg/Cm² | - | - | - | - | - | 10, 16, 25, 40 | 5 | 10, 16, 25, 40 | - | - | - | - | - | - | - | -
 | Process temperature | 0-100°C | 0-100°C | - | - | - | 0 -150 Deg C (Depends on liner) | 0 -150 Deg C (Depends on liner) | Integral PTFE – 120°C Remote PTFE – 180°C Others – 70°C | Up to 55°C | Up to 55°C | - | - | - | - | - | - | - | -
 | Electrode material | Stainless steel 316L | [NAME] bulb with epoxy body | - | - | - | Hastelloy C, SS 316 | Hastelloy C, SS 316 | SS 316L Std | SS 316L Std | SS 316L Std | - | - | - | - | - | - | - | -
 | [NAME] | - | MOC: ABS/Norryl with 20 NB  BSPF end connections, *[NAME] body for ATC Application | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Lining material | Rubber/PTFE | - | - | - | - | Rubber/PTFE | NBR Hard Rubber/EPDM/PTFE/EBONITE | [NAME]. Rubber | NA | [NAME]. Rubber | - | - | - | - | - | - | - | -
 | Cable | - | 1 Core Shielded 5 meter | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Body material | Cast Aluminum | ABS weather proof | Mild Steel | - | - | MS or SS | Mild Steel | Mild Steel | Mild Steel | Mild Steel | Mild Steel | Mild Steel | Mild Steel | Mild Steel/Pcoated | Mild Steel | Mild Steel | Mild Steel | Mild Steel
 | protection | IP65 | IP65 | - | - | - | - | IP67/IP68 | IP67 | IP 67 | IP 67 | - | - | - | - | - | - | - | -
 | Price |  |  |  |  | - | 25000 | 15000
 | Feature | • UNIQUE DESIGN ALLOWS INDICATOR DISPLAY ROTATION UPTO 270° • SUITABLE FOR ANY TYPE OF CONDUCTIVE FLUID • NEGLIGIBLE PRESSURE DROP • UNAFFECTED BY DENSITY OR VISCOSITY • HIGH TURN-DOWN RATIO • IDEAL FOR OUTDOOR INSTALLATION • COMMUNICATION READY for monitoring/data logging • HIGH ACCURACY • REVERSE FLOW WARNING • NO MOVING PARTS TO WEAR AND BREAK • ALL METERS INDIVIDUALLY CALIBRATED | TRACEABILITY to National Standards  •  PUSH BUTTON FRONT KEYS for easy set up  •  INDIVIDUAL HIGH & LOW SET POINT RELAY  for alarm or signal to PLC or can be used for proportional acid/alkali dosing  •  PROGRAMMABLE CONTROL DELAY TIME to prevent chattering  •  HYSTERISIS TO PREVENT RELAY CHATTERING  •  IN-BUILT DIAGNOSTICS for wrong calibration or sensor error  •  IN-BUILT ALARM ANNUNCIATOR  •  MANUAL/AUTOMATIC relay reset options | • COMPLETE RO LOGIC programmed • MIMIC DIAGRAM with 6 LEDs for I/O indication • 16X2 ALPHANUMERIC LCD DISPLAY with keypad for programming • AUTOMATICALLY FLUSHES the membrane during starting, stopping and after a set period, • Takes care of required MOTOR PROTECTION such as overload/single phasing/dry running • AUTO/MANUAL FACILITY (even in manual mode, motor protection doesn’t get bypassed) • TWO SEPARATE ROCKER SWITCHES TO SWITCH OFF/ON RAW WATER AND HIGH  • PRESSURE PUMP in manual mode • BIGGER TERMINALS FOR POWER (6 mm²) • PRESSFIT CONNECTOR FOR CONTROL TERMINALS FOR EASE OF WIRING • POWER AND CONTROL TERMINATION AT DIFFERENT LOCATION • IN BUILT OPERATION HOUR COUNTER • IN BUILT CONDUCTIVITY/TDS INDICATOR • PASSWORD PROTECTED settings • IN BUILT PROTECTION AGAINST UNDER & OVER VOLTAGE | • User Programmable. • Set Parameter password protected. • 4 key interface for onsite programming. • Message Display for on-going process. • Message Display for faults. • Front LED indication for status. • Direct display RUN-HOUR. • Direct display Total cumulative flow. The ARO Controller is  used to control RWP HPP motor as per condition of digitals inputs & it also protects the motors from unhealthy electrical condition like Under-load & Over-load. It also measure RUN-HOUR & total cumulative flow. | • Suited for Small and Medium size RO plants. • Preprogrammed RO operation, process interlocks and time delays. • Interactive Auto RO operation through panel keys in case of faults. • Provides for operation with Automatic Multi-Port valves through handshaking inputs. • Plant RUN time display • Flow Rate / Cumulative Volume display (Optional). • Conductivity display with pre-alarm and trip settings. • Easy User Programmable Settings. • Password Protected Process and Electrical Parameter Settings. • 4 Key Interface and LCD for Control and Onsite Programming. • Process Status Message Display. [NAME]. • Front Panel LED indications for active devices. • Auto / Manual Operation. • Pump Motor Voltage / Current display and Pump Motor Protection. • Phase Reversal and Single phasing protection. • Pump Protection in Manual Mode as well | • High in accuracy [NAME] handling Pressure: up to 25 bar  • Totally Independent of viscosity, the perfect choice for fluids with 1 to 106 mm2/s viscosity.  • Available with Low-pressure drop compared to other positive displacement meters  • Gives High resolution of display  • Provides Pulsation-free measurement, Insensitive to pulsating flows  • Provides complete Resistant to corrosion by advanced materials and bearings | • High in accuracy [NAME] handling Pressure: up to 25 bar  • Totally Independent of viscosity, the perfect choice for fluids with 1 to 106 mm2/s viscosity.  • Available with Low-pressure drop compared to other positive displacement meters  • Gives High resolution of display  • Provides Pulsation-free measurement, Insensitive to pulsating flows  • Provides complete Resistant to corrosion by advanced materials and bearings | • Based on Faraday’s law of electromagnetic induction • Coil assembly in hermetically sealed welded construction • High linearity due to characteristic magnetic field • High long-term stability and reliability • Flow tube sizes 10 mm to 3000 mm and above • Integral or remote transmitter • Field interchangeable electronics • Absolute zero stability and noise elimination due pulsed DC excitation | • Entire plastic body construction, therefore rust free • Suitable for virtually all types of conductive liquids • Remote transmitter type assembly • Suitable for pipe sizes of diameters 10 mm to 200 mm • No pressure loss • Light weight • Easy installation and absolutely low maintenance • Coil assembly in hermetically sealed welded construction • Field interchangeable electronics • Excellent accuracy and repeatability | • Based on Faraday’s law of electromagnetic induction • Flow tube sizes 10 mm to 600 mm • Integral or remote transmitter • Absolute zero stability and noise elimination due pulsed DC excitation • High linearity due to characteristic magnetic field • High long term stability and reliability • Field interchangeable electronics • Coil assembly in hermetically sealed welded construction | • 4 line LCD to show all plant information on the site. • Two flow sensors can be connected;it will show the Treated & Reject water flow in the display. • All flow sensors automatically pulse setting based on RO plant capacity. • Auto & Manual setting of RAW Water & High Pressure Pump. • AC Low and High Voltage protection to prevent pumps damage. [NAME] for Raw Water Tank, Dosing Tank & Treated/Pure Water Tank. • Low Pressure & High pressure [NAME]. • TDS & Conductivity. • All type / Mfr’s of Auto Multi Port Valves can be connected. • RO panel provide supply and control the UV, SV & Dosing Pump. • 8 LED indications to show the Power ON, Raw Water Tank Empty, Auto Flush, RWP ON,HPP ON, TWT Full, LPS & HPS Failed. • Password protection to prevent un-authorized changes at plant level. • RO panel having default factory settings option. • If any electronics PCB’s failed in the control panel, still RO plant runs in manual mode. • RO panel designed by using micro controllers to provides advanced intelligence solutions for water industry. • 3 Phase (RYB) Voltage monitoring, Display & Protects from Un-Balance AC Voltages. | • DUST VERMIN PROOF ENCLOSURE • COMPLETE RO LOGIC programmed • IDEALLY SUITABLE FOR SMALL SIZE RO PLANTS • AUTO/MANUAL FACILITY (Manual mode is  ideally suited for [NAME]) • AUTOMATICALLY FLUSHES the membrane during starting and stopping • PROCESS FLOW DIAGRAM WITH BRIGHT LED for ease of understanding • FACILITY TO BYPASS LPS/FLOATY/BOTH IN AUTO MODE • MIMIC DIAGRAM with 11 LEDs for I/O indication • PREPROGRAMMED SETTINGS eliminates need of skilled operator • SEPARATE POWER AND CONTROL TERMINALS • PRESSFIT CONNECTOR for input terminals for ease of wiring • LARGE TERMINALS for rugged wiring • INBUILT TDS INDICATOR | • On/Off button • Mimic diagram with 6 LEDs indications for Power, Pump running & water level • Delay time for HPP protect to dry run. • RWP & HPP on/off with water level sensor | • INTUITIVE & PATENTED USER INTERFACE • 13 key makes setting much simpler • COMPLETE RO LOGIC PROGRAMMED • Quick Access to critical settings • Logical  START/STOP with single key • Different colored backlit to show plant status • SINGLE LINE MIMIC DIAGRAM with 13 LEDs for I/O indication • 16X2 ALPHANUMERIC LCD DISPLAY with colour changing feature Bluetooth connectivity plant status will be reflected on smart phone(Optional) • Can pair with Android device for data monitoring and control EASY MOUNTING WITH NUT AND STUD FUSE FAILURE INDICATION LARGER POWER TERMINALS (6 Sq. [NAME]) for easy wiring REMOVABLE TERMINALS for input •  AUTOMATICALLY FLUSHES the membrane during starting, stopping and after a set period,     takes care of required MOTOR PROTECTION such as overload/single phasing/dry running •  AUTO/MANUAL FACILITY (even in manual mode, motor protection doesn’t get bypassed) • Equipped to SUIT AUTO-MULTIPORT VALVE in pre-treatment • in built protection against OVER & UNDER VOLTAGE • NOTIFICATION FOR FILTER BACKWASH DUE & PLANT SERVICING DUE • TIME LOCK FACILITY, PANEL ITSELF CAN WORK AS RECOVERY AGENT • INBUILT FLOW RATE INDICATION WITH TOTALISER • INBUILT OF HOUR COUNTER • INBUILT COND/TDS INDICATOR | • Features - 4 line LCD to show all plant information on the site. - GSM based-Real time data & the fault reason will be transfer to web, [NAME] APP and two mobile phones. - Through App and Mobile phone, RO plant can be controlled for all its functions. • Parameter- Sent after set interval of time - Unit NO - Today’s RO-LTRS - RO Water & Reject water Flow Rate - RO Work Hour - Voltage - Raw Water Pump & High Pressure Pump AMPS - TDS - GSM Signal • Faults/Alerts- Sent immediately - Voltage(Under or Over) Trip - Low Pressure Trip - High Pressure Trip - Treated Water Tank Full - Dosing Tank Empty - RWP Overload - HPP Overload | • Auto & Manual Facility Inbuilt • Complete RO Logic Pre Program • Automatic Flushing Facility Inbuilt • Mimic Diagram with 9 LEDs for Plants Status • Push & Pull Type Heavy Duty Terminals for Easy Wiring • High Pressure & Low Pressure Tripping Facilities Inbuilt • RWT & TWT LOW & High Level Tripping Facilities Inbuilt • Alphabetical Rod 7 Segment Display for Online TDS | • Auto & Manual Facility Inbuilt • Complete RO Logic Pre Program • Automatic Slow & Fast Flushing Facility Inbuilt • Mimic Diagram with 6 LEDs for I/O Visualization • Heavy Duty Terminals for Wiring • Alphabetical 16x2 Blue / White LCD Display for Batter visualization • Password Protection Facility for Plant Safety and Security • Voltage, Ampere, [NAME], Single Phasing, Pressure & Level Tripping Facilities Inbuilt • Display Continuously Scrolling with Total Plant Run Hours, TDS, RWP / HPP Pumps Ampere • Provision for Every Types of Auto MPV & GSM Facilities Optional • Tripping - Over & Under Ampere Tripping - Dry Run Tripping - RWP & HPP Single Phase Tripping - Low / High Pressure & Level Tripping | • Auto & Manual Facility Inbuilt • Complete RO Logic Pre Program • Automatic Slow & Fast Flushing Facility Inbuilt • heavy Duty Terminals for Wiring • Alphabetical 16x2 Blue / White LCD Display for Batter visualization • Password Protection Facility for Plant Safety and Security • Voltage, Ampere, [NAME], Single Phasing, Pressure & Level Tripping Facilities Inbuilt • Display Continuously Scrolling with Total Plant Run Hours, TDS, RWP / HPP Pumps Ampere • Provision for Every Types of Auto MPV & GSM Facilities Optional • Tripping - Over & Under Ampere Tripping - Dry Run Tripping - RWP & HPP Single Phase Tripping - Low / High Pressure & Level Tripping