Skip to main content
U.S. Department of Energy
Office of Scientific and Technical Information

Use spreadsheets for better refinery operation

Journal Article · · Hydrocarbon Process.; (United States)
OSTI ID:7004865

The advent within the last several years of sophisticated, user-oriented, computer techniques of spreadsheet programming has opened the door to consideration of an alternative to linear programming. It has become possible to represent all of the unit operations and stream flows of a major petroleum refinery on a single spreadsheet and have that spreadsheet establish a continuous overall refinery balance that responds to every change the engineer wishes to explore. The response time for a new balance can vary from about 5 to 15 seconds using widely available present-day microcomputers. With faster microprocessors becoming available, it is expected to be less than 1 second within just a few years. The spreadsheet, in effect, carries out the same balancing that required many laborious hours of work 30 years ago. It does this balancing without optimization; the refinery engineer interacts with the spreadsheet program to make optimizing adjustments.

Research Organization:
Mobil Research and Development Corp., Princeton, NJ
OSTI ID:
7004865
Journal Information:
Hydrocarbon Process.; (United States), Journal Name: Hydrocarbon Process.; (United States) Vol. 65:10; ISSN HYPRA
Country of Publication:
United States
Language:
English

Similar Records

Linear program optimization of refinery spreadsheets
Journal Article · Sat Oct 31 23:00:00 EST 1987 · Hydrocarbon Process.; (United States) · OSTI ID:5698446

PCS are vital refinery balance and profit tools
Journal Article · Sun Mar 02 23:00:00 EST 1986 · Oil Gas J.; (United States) · OSTI ID:5944630

Refinery spreadsheet highlights microcomputer process applications
Journal Article · Sun Jan 22 23:00:00 EST 1984 · Oil Gas J.; (United States) · OSTI ID:7077031