Spreadsheet: 85103d1285168024-combining-two-formulas-sample
Sheet: Sheet1

Block Valves | SIZE: | TYPE: | RATING: | LINE #: | SERVICE: | MATERIAL & RATING: | [NAME]: | PRESSURE RANGE: | TEMP RANGE: | VOC TAG NUMBER: | TRIM: | CODE NO.: | PIPE SPEC.:
Exchangers | SIZE: |  | TEMA: | SHELL DES PRESS: | SHELL DES TEMP: | TUBE DES PRESS: | TUBE DES TEMP: | SHELL MATL: | SHELL THK: | SHELL CA: | TUBE MATL: | CHANNEL MATL: | CHANNEL CA: | BUNDLE WEIGHT:
Drums | DESIGN PRESS.: | DESIGN TEMP: | SHELL MATL.: | SHELL THK.: | [NAME]. : | SHELL AREA: | INTERNALS: | SKIRT HT.: | PWHT: | SHELL DIA.: | SHELL T/T: | FLG.RATING: | SERVICE: | TYPE:
Level Gauge | GAUGE GLASSES: | TYPE: | CONNECTIONS NPT: | CONNECTIONS LOC.: | MATERIAL: | RATING: | GAUGE COCKS: | TYPE: | VESSEL CONNECTION: | GAUGE CONNECTION: | DRAIN CONNECTION: | MFR MODEL #:
Towers | DESIGN PRESS.: | DESIGN TEMP: | SHELL MATL.: | SHELL THK.: | [NAME]. : | SHELL AREA: | INTERNALS: | SKIRT HT.: | PWHT: | SIZE DIA.: | SIZE T/T: | FLG.RATING: | SERVICE: | TYPE:
PSV's | TYPE or STYLE: | ORIFICE: | SET PRESS.: | BACK PRESS.: | CALIBRATION DATE: | SIZE INLET: | SIZE OUTLET: | CONNECTION TYPE:
Steam Traps | TRAP #: | CONNECTION SIZE: | CONNECTION TYPE: | ORIFICE SIZE: | APPLICATION: | STEAM PRESSURE: | TYPE:
Filter | DESIGN PRESS.: | DESIGN TEMP: | SHELL MATL.: | SHELL THK.: | [NAME]. : | TYPE FILTER: | SIZE DIA.: | SIZE T/T: | FLG.RATING: | FILTER MEDIA TYPE: | MEDIA [NAME]: | SERVICE: | TYPE:
Heater | CONV. SECT. SKIN: | CONV. TUBE DP/VP: | CONV. TUBE MATERIAL: | CONV. TUBE CA: | CONV. TUBE OD: | CONV. TUBE THK: | RADIANT SECTION SKIN: | RADIANT TUBE DP/VP: | RADIANT TUBE MATERIAL: | RADIANT TUBE CA: | RADIANT TUBE OD: | RADIANT TUBE THK:
Block Valves
Drums
Towers
Steam Traps
Exchangers | TYPE: | DUTY: | SHELL AREA: |  | TUBE COUNT: | TUBE SIZE: | TUBE LENGTH: |  |  |  | PROCESS SH: | PROCESS TU: | HYDRO. PRESS: | SHELL PRESS: | TUBE PRESS:
Level Gauge | GUAGE VISIBLE LENGTH: | VESSEL CENTERS LENGTH: | OPERATING PRESS.: | OPERATING TEMP.: | SERVICE:
PSV's | MATL. BODY: | MATL. BONNET: | MATL. DISK: | MATL. SEAT: | MATL. SPRING: | MATL. GUIDE:
Filter
Heater
 |  |  |  |  | Sizes | Ratings | Types
Zones | Zone1 List |  |  |  | 1" | 125 | GATE
Zone1 | 602000 | [NAME] |  |  | 1 1/2" | 150 | CHECK
Zone2 | 602600 | Boiler House #3 |  |  | 2" | 300 | STOP CHECK
Zone3 | 603000 | Light Oil Treating Plant |  |  | 2 1/2" | 600 | GLOBE
Zone4 | 603700 | S Zorb Unit |  |  | 3" | 900 | BUTTERFLY
Zone5 | 605500 | FCC Unit |  |  | 4" | 1500 | NEEDLE
Zone6 | Zone2 List |  |  |  | 6" | 2500 | BALL
Zone7 | 605000 | Crude Unit |  |  | 8" |  | ORBIT
 | 605100 | [NAME] |  |  | 10" |  | GENERIC ROTARY
 | 605200 | Plant Air System |  |  | 12" |  | PLUG
 | 606200 | Hydrotreater #2 |  |  | 14" |  | POST INDICATOR
 | 607500 | Coker Unit |  |  | 16" |  | DIAPHRAGM
 | 607600 | Calciner Unit |  |  | 18" |  | 3-WAY
 | 607700 | Material Handling |  |  | 20" |  | 4-WAY
 | [NAME] |  |  |  | 24" |  | PINCH
 | 603100 | Shell Joint Venture |  |  | 26" |  | MINIMUM FLOW/BYPASS
 | 603200 | LPG 2 / Flares - East & West |  |  | 28" |  | ANGLE
 | 603500 | Sulfur Plant |  |  | 30" |  | KNIFE
 | 606300 | Reformer #3 |  |  | 36" |  | SLIDE
 | [NAME] |  |  |  | 42" |  | RAM
 | 602500 | Boiler House #2
 | 607000 | Alky Cooling/Defluorinator
 | 607100 | Alkylation Unit #1
 | 607200 | Alkylation Unit #2
 | 608000 | Depropanizer/Caustic Handling
 | 608200 | Udex [NAME]
 | Zone5 List
 | 601400 | Oil Movements
 | 601800 | Operational Environmental Service
 | Zone6 List
 | 600000 | Master Refining
 | 600100 | Storehouse
 | 600200 | Economics, Planning and Scheduling
 | 600300 | Purchasing
 | 600400 | Human Resources
 | 600500 | Engineering
 | 600700 | Process Engineering
 | 600800 | Maintenance
 | 600900 | Operations
 | 600950 | Operations Administrative
 | 601000 | Administrative
 | 601010 | Pasadena Refining Support Serv
 | 601100 | Emergency Response
 | 601200 | Security
 | 601300 | Health Services
 | 601500 | Laboratory
 | 601600 | Environmental Matters
 | 601700 | Safety Programs
 | 601900 | [NAME]
 | 602100 | Environmental Audit 2005 Response
 | 602200 | Extraordinary Safety Affairs
 | 602300 | Environmental Engineer
 | 602400 | Environmental Management System
 | 602700 | Tank 203 Project
 | 602800 | Government Grant Funds
 | 603300 | Refinery Inspections
 | 603350 | Inspection Onstream
 | 603400 | OSHA
 | 603800 | Reliability
 | 608800 | Pasadena Distributed Control
 | 609100 | NOx MECT Purchase
 | 609200 | RCRA Corrective Action
 | 609500 | Refinery Plant Infrastructure
 | 902010 | S&T - Administrative
 | 902020 | S&T - Crude
 | 902050 | Accounting
 | 903610 | Credit
 | 906301 | IT
 | 910000 | [NAME]
 | 920000 | HSE Performance Improvements
 | 930000 | Expansion/Revamp Owner Cost
 | 940000 | Remote Control Center
 | [NAME]
 | 700110 | PRSI West-Storehouse
 | 700210 | PRSI West-Economics & Planning
 | 700310 | PRSI West-Purchasing
 | 700410 | PRSI West-Human Resources
 | 700510 | PRSI West-Engineering
 | 700810 | PRSI West-Maintenance
 | 700910 | PRSI West-Operations
 | 701010 | PRSI West-Administrative
 | 701110 | PRSI West-Emergency
 | 701210 | PRSI West-Security
 | 701310 | PRSI West-Health Services
 | 701510 | PRSI West-Laboratory
 | 701610 | PRSI West-Environmental
 | 701710 | PRSI West-Safety
 | 701910 | PRSI West-Training
 | 702010 | PRSI West-Complex Cooling Tower
 | 709510 | PRSI West-Infratstructure
 | 709610 | PRSI West-Sulfur Recovery Unit
 | 709710 | PRSI West-Amine
 | 709810 | PRSI West-Sour Water Stripper
 | 709910 | PRSI West-Coker
 | 710010 | PRSI West-Cat Feed Hydrotreater
 | 710110 | PRSI West-Ultra Low Sulfur Diesel
 | 710210 | PRSI West-CDU/VDU
Block Valves | SIZE: | TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | RATING: | LINE #: | SERVICE: | MATERIAL & RATING: | [NAME]: | PRESSURE RANGE: | TEMP RANGE: | VOC TAG NUMBER: | TRIM: | CODE NO.: | PIPE SPEC.:
Exchangers | SIZE: | TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | PROCESS SH: | PROCESS TU: | TEMA: | SHELL DES PRESS: | SHELL DES TEMP: | SHELL MATL: | SHELL THK: | SHELL CA: | TUBE MATERIAL: | TUBE COUNT: | TUBE SIZE: | TUBE LENGTH: | CHANNEL MATL: | CHANNEL CA: | BUNDLE WEIGHT:
Drums | SIZE: | TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | DESIGN PRESS: | DESIGN TEMP: | SHELL MATL: | SHELL THK: | SHELL CA: | SHELL AREA: | INTERNALS: | SKIRT HT: | PWHT: | SIZE DIA.: | SIZE T/T: | FLG RATING:
Level Gauge | SIZE: | TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | OPER. PRESS: | OPER. TEMP: | GAUGE GLASSES: | CONNECTIONS NPT: | CONNECTIONS LOC.: | MATERIAL: | RATING: | GAUGE COCKS: | TYPE: | VESSEL CONNECTION: | GAUGE CONNECTION: | DRAIN CONNECTION: | MFR MODEL #: | GAUGE GLASSES: | GAUGE VISIBLE LENGTH:
Towers | SIZE: | TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | DESIGN PRESS: | DESIGN TEMP: | SHELL MATL: | SHELL THK: | SHELL CA: | SHELL AREA: | INTERNALS: | SKIRT HT: | PWHT: | SIZE DIA.: | SIZE T/T: | FLG RATING:
PSV's | TYPE or STYLE: | SET PRESS: |  | MFG: | MODEL #: | SERIAL #: |  | ORIFICE: | BACK PRESS: | CALIBRATION DATE: | SIZE INLET: | SIZE OUTLET: | CONNECTION TYPE: | MATL BODY: | MATL BONNET: | MATL DISK: | MATL SPRING: | MATL GUIDE:
Steam Traps | TYPE: | APPLICATION TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | LOCATION/GRID: | CONNECTION SIZE: | CONNECTION TYPE: | ORIFICE SIZE: | STEAM PRESSURE:
Filter | SERVICE: | TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | DESIGN PRESS: | DESIGN TEMP: | SHELL MATL: | SHELL THK: | SHELL CA: | TYPE FILTER: | SIZE DIA.: | SIZE T/T: | FLG RATING: | FILTER MEDIA TYPE: | MEDIA [NAME]:
Heater | SERVICE: | TYPE: |  | MFG: | MODEL #: | SERIAL #: |  | CONV. SECT. SKIN: | CONV.TUBE DP/VP: | CONV. TUBE MATERIAL: | CONV. TUBE CA: | CONV. TUBE OD: | CONV. TUBE THK: | RADIANT SECT. SKIN: | RADIANT TUBE DP/VP: | RADIANT TUBE MATERIAL: | RADIANT TUBE CA: | RADIANT TUBE OD: | RADIANT TUBE THK: