American Oil and Gas Reporter - October 2016 - 77

(169 parameters for a four-throw unit)
for every operating point. Needless to
say, this results in a very large database.
The three primary parameters of power,
throughput, and compressor warning
codes were extracted from the CSV file
and written into tables. Finally, the tables
were combined for the solution look-up.
Since this process was applied to a wide
variety of compressors with unique configurations, a Microsoft® Access™ database was incorporated to store the various
unit model tables.
The Access file also contains several
constants for each unique compressor
and tag names, and data paths for both
input and output parameters in the
CygNet™ supervisory control and data
acquisition software. The constants required for determining the solution are
rated driver power, rated driver speed,
auxiliary power, station pressure drop,
and limits of the pressure ranges used
for each unique compressor database.
Input parameters from CygNet are
unit suction pressure, unit discharge pressure, field pressure, current load step,
and actual driver load. Output parameters
are read from the spreadsheet and passed
back to CygNet, and include throughput
at current condition, throughput at optimized condition, optimized load step,
and optimized suction pressure. Several
additional output parameters are passed
through the Access file to enhance the
presentation of recommendations.
Facilitating Changes
The Access file contains all the variables and model tables for the various

compressors, and also has adjustable settings to facilitate changes. This allows
the spreadsheet to remain unchanged if
compressors are added, deleted or modified. The spreadsheet has a macro programmed to read the data path from the
Access file and read/write data from/to
CygNet. Once the input data and database
are written to the spreadsheet, calculations
initiate to both look up data at the current
configuration and solve for the optimal
condition (i.e., maximum throughput).
One key to this logic is that it will not
solve for an unsafe condition by reading
the site-rated power and warning codes
from the Ariel Performance Program incorporated into the database. Another key
that differentiates this method is that it
calculates the maximum available suction
pressure to use in the look-up. Once the
spreadsheet completes the tasks for one
compressor and passes the results to
CygNet, the process repeats for the next
compressor on the list.
To reduce time to complete the process,
all like-kind compressors use the same
model table, and a new table is not written
until a unit with a new compressor configuration is read. The Access file is set
up to easily differentiate like-kind compressors and associated tables.
The final piece of the optimization
tool is a screen developed in CygNet to
allow operations personnel to easily and
visually monitor the compressor fleet. It
contains several parameters, but the primary ones are compressor utilization (the
main parameter to gauge optimization of
each compressor), recommended load
step, and recommended suction pressure.

FIGURE 4
Wattenberg Compressor Utilization Screen

OCTOBER 2016 77



American Oil and Gas Reporter - October 2016

Table of Contents for the Digital Edition of American Oil and Gas Reporter - October 2016

Contents
American Oil and Gas Reporter - October 2016 - Cover1
American Oil and Gas Reporter - October 2016 - Cover2
American Oil and Gas Reporter - October 2016 - Contents
American Oil and Gas Reporter - October 2016 - 4
American Oil and Gas Reporter - October 2016 - 5
American Oil and Gas Reporter - October 2016 - 6
American Oil and Gas Reporter - October 2016 - 7
American Oil and Gas Reporter - October 2016 - 8
American Oil and Gas Reporter - October 2016 - 9
American Oil and Gas Reporter - October 2016 - 10
American Oil and Gas Reporter - October 2016 - 11
American Oil and Gas Reporter - October 2016 - 12
American Oil and Gas Reporter - October 2016 - 13
American Oil and Gas Reporter - October 2016 - 14
American Oil and Gas Reporter - October 2016 - 15
American Oil and Gas Reporter - October 2016 - 16
American Oil and Gas Reporter - October 2016 - 17
American Oil and Gas Reporter - October 2016 - 18
American Oil and Gas Reporter - October 2016 - 19
American Oil and Gas Reporter - October 2016 - 20
American Oil and Gas Reporter - October 2016 - 21
American Oil and Gas Reporter - October 2016 - 22
American Oil and Gas Reporter - October 2016 - 23
American Oil and Gas Reporter - October 2016 - 24
American Oil and Gas Reporter - October 2016 - 25
American Oil and Gas Reporter - October 2016 - 26
American Oil and Gas Reporter - October 2016 - 27
American Oil and Gas Reporter - October 2016 - 28
American Oil and Gas Reporter - October 2016 - 29
American Oil and Gas Reporter - October 2016 - 30
American Oil and Gas Reporter - October 2016 - 31
American Oil and Gas Reporter - October 2016 - 32
American Oil and Gas Reporter - October 2016 - 33
American Oil and Gas Reporter - October 2016 - 34
American Oil and Gas Reporter - October 2016 - 35
American Oil and Gas Reporter - October 2016 - 36
American Oil and Gas Reporter - October 2016 - 37
American Oil and Gas Reporter - October 2016 - 38
American Oil and Gas Reporter - October 2016 - 39
American Oil and Gas Reporter - October 2016 - 40
American Oil and Gas Reporter - October 2016 - 41
American Oil and Gas Reporter - October 2016 - 42
American Oil and Gas Reporter - October 2016 - 43
American Oil and Gas Reporter - October 2016 - 44
American Oil and Gas Reporter - October 2016 - 45
American Oil and Gas Reporter - October 2016 - 46
American Oil and Gas Reporter - October 2016 - 47
American Oil and Gas Reporter - October 2016 - 48
American Oil and Gas Reporter - October 2016 - 49
American Oil and Gas Reporter - October 2016 - 50
American Oil and Gas Reporter - October 2016 - 51
American Oil and Gas Reporter - October 2016 - 52
American Oil and Gas Reporter - October 2016 - 53
American Oil and Gas Reporter - October 2016 - 54
American Oil and Gas Reporter - October 2016 - 55
American Oil and Gas Reporter - October 2016 - 56
American Oil and Gas Reporter - October 2016 - 57
American Oil and Gas Reporter - October 2016 - 58
American Oil and Gas Reporter - October 2016 - 59
American Oil and Gas Reporter - October 2016 - 60
American Oil and Gas Reporter - October 2016 - 61
American Oil and Gas Reporter - October 2016 - 62
American Oil and Gas Reporter - October 2016 - 63
American Oil and Gas Reporter - October 2016 - 64
American Oil and Gas Reporter - October 2016 - 65
American Oil and Gas Reporter - October 2016 - 66
American Oil and Gas Reporter - October 2016 - 67
American Oil and Gas Reporter - October 2016 - 68
American Oil and Gas Reporter - October 2016 - 69
American Oil and Gas Reporter - October 2016 - 70
American Oil and Gas Reporter - October 2016 - 71
American Oil and Gas Reporter - October 2016 - 72
American Oil and Gas Reporter - October 2016 - 73
American Oil and Gas Reporter - October 2016 - 74
American Oil and Gas Reporter - October 2016 - 75
American Oil and Gas Reporter - October 2016 - 76
American Oil and Gas Reporter - October 2016 - 77
American Oil and Gas Reporter - October 2016 - 78
American Oil and Gas Reporter - October 2016 - 79
American Oil and Gas Reporter - October 2016 - 80
American Oil and Gas Reporter - October 2016 - 81
American Oil and Gas Reporter - October 2016 - 82
American Oil and Gas Reporter - October 2016 - 83
American Oil and Gas Reporter - October 2016 - 84
American Oil and Gas Reporter - October 2016 - 85
American Oil and Gas Reporter - October 2016 - 86
American Oil and Gas Reporter - October 2016 - 87
American Oil and Gas Reporter - October 2016 - 88
American Oil and Gas Reporter - October 2016 - 89
American Oil and Gas Reporter - October 2016 - 90
American Oil and Gas Reporter - October 2016 - 91
American Oil and Gas Reporter - October 2016 - 92
American Oil and Gas Reporter - October 2016 - 93
American Oil and Gas Reporter - October 2016 - 94
American Oil and Gas Reporter - October 2016 - 95
American Oil and Gas Reporter - October 2016 - 96
American Oil and Gas Reporter - October 2016 - 97
American Oil and Gas Reporter - October 2016 - 98
American Oil and Gas Reporter - October 2016 - 99
American Oil and Gas Reporter - October 2016 - 100
American Oil and Gas Reporter - October 2016 - 101
American Oil and Gas Reporter - October 2016 - 102
American Oil and Gas Reporter - October 2016 - 103
American Oil and Gas Reporter - October 2016 - 104
American Oil and Gas Reporter - October 2016 - 105
American Oil and Gas Reporter - October 2016 - 106
American Oil and Gas Reporter - October 2016 - 107
American Oil and Gas Reporter - October 2016 - 108
American Oil and Gas Reporter - October 2016 - 109
American Oil and Gas Reporter - October 2016 - 110
American Oil and Gas Reporter - October 2016 - 111
American Oil and Gas Reporter - October 2016 - 112
American Oil and Gas Reporter - October 2016 - 113
American Oil and Gas Reporter - October 2016 - 114
American Oil and Gas Reporter - October 2016 - 115
American Oil and Gas Reporter - October 2016 - 116
American Oil and Gas Reporter - October 2016 - 117
American Oil and Gas Reporter - October 2016 - 118
American Oil and Gas Reporter - October 2016 - 119
American Oil and Gas Reporter - October 2016 - 120
American Oil and Gas Reporter - October 2016 - 121
American Oil and Gas Reporter - October 2016 - 122
American Oil and Gas Reporter - October 2016 - Cover3
American Oil and Gas Reporter - October 2016 - Cover4
http://staging.nxtbook.com/nxtbooks/aogr/201702/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201701/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201612/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201611/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201610/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/pbios2016_programguide/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201609/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201608/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201607/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201606/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201605/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201604/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201603/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201602/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201601/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201512/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201511/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201510/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201509/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201508/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201507/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201506/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201505/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201504/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201503/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201502/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201501/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201412/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201411/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201410/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201409/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/pbios2014_programguide/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201408/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201407/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201406/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201405/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201404/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201403/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201402/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201401/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201312/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201311/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201310/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201309/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201308/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201307/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201306/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201305/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201304/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201303/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201302/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201301/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201212/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201211/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201210/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201209/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/2012_pbios/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201208/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201207/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201206/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201205/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201204/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201203/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201202/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201201/stage.php
http://staging.nxtbook.com/nxtbooks/demo/aogr_clone/stage.php
http://staging.nxtbook.com/nxtbooks/aogr/201112/stage.php
https://www.nxtbookmedia.com