American Oil and Gas Reporter - June 2017 - 87

SpecialReport: Artificial Lift Technology
Data Consolidation

correct updated data, the automated work-

changes that should be made to systems

well equipment and SCADA data are

logical progression is performed to opti-

fluid. The logic is performed within ap-

Well information, production volumes,

necessary to carry out the RPOT logic

and calculations. Dynamic data sources

flow process ensures that the correct
mize rod-pumped systems.

As depicted in Figure 3, the RPOT

feed into the RPOT through information

logic quality checks data, determines if a

data prior to creating visualizations. This

well's inflow, and specifies equipment

links, or database queries that narrow the

functionality removes the need for data

rod pump is optimally sized based on the

not delivering the optimal amount of

proximately 50 calculated columns in the

RPOT's master table, stepping through a
progression that considers the most cost-

effective and time-effective actions first.
Optimizing rod pumps is still an iter-

dumps, and ensures that the correct data
are brought into the RPOT. As a result,

users are able to perform analyses faster,

more frequently and with better confi-

dence, knowing that they are looking at
the right datasets.

Data are structured so that each row

corresponds to a given well on a given
day. The corresponding columns provide
well information, production volumes,
well equipment and SCADA readings

for a given well on a given day. After

adjusting the query to limit data to the
necessary amount, the RPOT brings in

the previous 100 days of data for the 125
rod-pumped wells.

A critical step in consolidating data is

utilizing an "information designer" feature
that reduces the dataset to the appropriate

size, using prompts, filters, data slicing,
pivoting, transformations and aggregating.

For Denbury, tens of millions of records

across multiple servers are reduced to
1.25 million cells in the RPOT's master

database, summarizing data from 12,500
rows and 100 columns.

Automated Workflows

After the data are consolidated into a

master table, a series of routine calculations
are performed to generate ROAs for each

well, based on the adjustable user inputs

(Figure 2). While the data consolidation
step ensures that users are looking at the

JUNE 2017 87



http://www.libertylift.com

American Oil and Gas Reporter - June 2017

Table of Contents for the Digital Edition of American Oil and Gas Reporter - June 2017

Contents
American Oil and Gas Reporter - June 2017 - 1
American Oil and Gas Reporter - June 2017 - 2
American Oil and Gas Reporter - June 2017 - Contents
American Oil and Gas Reporter - June 2017 - 4
American Oil and Gas Reporter - June 2017 - 5
American Oil and Gas Reporter - June 2017 - 6
American Oil and Gas Reporter - June 2017 - 7
American Oil and Gas Reporter - June 2017 - 8
American Oil and Gas Reporter - June 2017 - 9
American Oil and Gas Reporter - June 2017 - 10
American Oil and Gas Reporter - June 2017 - 11
American Oil and Gas Reporter - June 2017 - 12
American Oil and Gas Reporter - June 2017 - 13
American Oil and Gas Reporter - June 2017 - 14
American Oil and Gas Reporter - June 2017 - 15
American Oil and Gas Reporter - June 2017 - 16
American Oil and Gas Reporter - June 2017 - 17
American Oil and Gas Reporter - June 2017 - 18
American Oil and Gas Reporter - June 2017 - 19
American Oil and Gas Reporter - June 2017 - 20
American Oil and Gas Reporter - June 2017 - 21
American Oil and Gas Reporter - June 2017 - 22
American Oil and Gas Reporter - June 2017 - 23
American Oil and Gas Reporter - June 2017 - 24
American Oil and Gas Reporter - June 2017 - 25
American Oil and Gas Reporter - June 2017 - 26
American Oil and Gas Reporter - June 2017 - 27
American Oil and Gas Reporter - June 2017 - 28
American Oil and Gas Reporter - June 2017 - 29
American Oil and Gas Reporter - June 2017 - 30
American Oil and Gas Reporter - June 2017 - 31
American Oil and Gas Reporter - June 2017 - 32
American Oil and Gas Reporter - June 2017 - 33
American Oil and Gas Reporter - June 2017 - 34
American Oil and Gas Reporter - June 2017 - 35
American Oil and Gas Reporter - June 2017 - 36
American Oil and Gas Reporter - June 2017 - 37
American Oil and Gas Reporter - June 2017 - 38
American Oil and Gas Reporter - June 2017 - 39
American Oil and Gas Reporter - June 2017 - 40
American Oil and Gas Reporter - June 2017 - 41
American Oil and Gas Reporter - June 2017 - 42
American Oil and Gas Reporter - June 2017 - 43
American Oil and Gas Reporter - June 2017 - 44
American Oil and Gas Reporter - June 2017 - 45
American Oil and Gas Reporter - June 2017 - 46
American Oil and Gas Reporter - June 2017 - 47
American Oil and Gas Reporter - June 2017 - 48
American Oil and Gas Reporter - June 2017 - 49
American Oil and Gas Reporter - June 2017 - 50
American Oil and Gas Reporter - June 2017 - 51
American Oil and Gas Reporter - June 2017 - 52
American Oil and Gas Reporter - June 2017 - 53
American Oil and Gas Reporter - June 2017 - 54
American Oil and Gas Reporter - June 2017 - 55
American Oil and Gas Reporter - June 2017 - 56
American Oil and Gas Reporter - June 2017 - 57
American Oil and Gas Reporter - June 2017 - 58
American Oil and Gas Reporter - June 2017 - 59
American Oil and Gas Reporter - June 2017 - 60
American Oil and Gas Reporter - June 2017 - 61
American Oil and Gas Reporter - June 2017 - 62
American Oil and Gas Reporter - June 2017 - 63
American Oil and Gas Reporter - June 2017 - 64
American Oil and Gas Reporter - June 2017 - 65
American Oil and Gas Reporter - June 2017 - 66
American Oil and Gas Reporter - June 2017 - 67
American Oil and Gas Reporter - June 2017 - 68
American Oil and Gas Reporter - June 2017 - 69
American Oil and Gas Reporter - June 2017 - 70
American Oil and Gas Reporter - June 2017 - 71
American Oil and Gas Reporter - June 2017 - 72
American Oil and Gas Reporter - June 2017 - 73
American Oil and Gas Reporter - June 2017 - 74
American Oil and Gas Reporter - June 2017 - 75
American Oil and Gas Reporter - June 2017 - 76
American Oil and Gas Reporter - June 2017 - 77
American Oil and Gas Reporter - June 2017 - 78
American Oil and Gas Reporter - June 2017 - 79
American Oil and Gas Reporter - June 2017 - 80
American Oil and Gas Reporter - June 2017 - 81
American Oil and Gas Reporter - June 2017 - 82
American Oil and Gas Reporter - June 2017 - 83
American Oil and Gas Reporter - June 2017 - 84
American Oil and Gas Reporter - June 2017 - 85
American Oil and Gas Reporter - June 2017 - 86
American Oil and Gas Reporter - June 2017 - 87
American Oil and Gas Reporter - June 2017 - 88
American Oil and Gas Reporter - June 2017 - 89
American Oil and Gas Reporter - June 2017 - 90
American Oil and Gas Reporter - June 2017 - 91
American Oil and Gas Reporter - June 2017 - 92
American Oil and Gas Reporter - June 2017 - 93
American Oil and Gas Reporter - June 2017 - 94
American Oil and Gas Reporter - June 2017 - 95
American Oil and Gas Reporter - June 2017 - 96
American Oil and Gas Reporter - June 2017 - 97
American Oil and Gas Reporter - June 2017 - 98
American Oil and Gas Reporter - June 2017 - 99
American Oil and Gas Reporter - June 2017 - 100
American Oil and Gas Reporter - June 2017 - 101
American Oil and Gas Reporter - June 2017 - 102
American Oil and Gas Reporter - June 2017 - 103
American Oil and Gas Reporter - June 2017 - 104
American Oil and Gas Reporter - June 2017 - 105
American Oil and Gas Reporter - June 2017 - 106
American Oil and Gas Reporter - June 2017 - 107
American Oil and Gas Reporter - June 2017 - 108
American Oil and Gas Reporter - June 2017 - 109
American Oil and Gas Reporter - June 2017 - 110
American Oil and Gas Reporter - June 2017 - 111
American Oil and Gas Reporter - June 2017 - 112
American Oil and Gas Reporter - June 2017 - 113
American Oil and Gas Reporter - June 2017 - 114
American Oil and Gas Reporter - June 2017 - 115
American Oil and Gas Reporter - June 2017 - 116
American Oil and Gas Reporter - June 2017 - 117
American Oil and Gas Reporter - June 2017 - 118
American Oil and Gas Reporter - June 2017 - 119
American Oil and Gas Reporter - June 2017 - 120
American Oil and Gas Reporter - June 2017 - 121
American Oil and Gas Reporter - June 2017 - 122
American Oil and Gas Reporter - June 2017 - 123
American Oil and Gas Reporter - June 2017 - 124
American Oil and Gas Reporter - June 2017 - 125
American Oil and Gas Reporter - June 2017 - 126
American Oil and Gas Reporter - June 2017 - 127
American Oil and Gas Reporter - June 2017 - 128
American Oil and Gas Reporter - June 2017 - 129
American Oil and Gas Reporter - June 2017 - 130
American Oil and Gas Reporter - June 2017 - 131
American Oil and Gas Reporter - June 2017 - 132
https://www.nxtbook.com/nxtbooks/aogr/202404
https://www.nxtbook.com/nxtbooks/aogr/202403
https://www.nxtbook.com/nxtbooks/aogr/202402
https://www.nxtbook.com/nxtbooks/aogr/202401
https://www.nxtbook.com/nxtbooks/aogr/202312
https://www.nxtbook.com/nxtbooks/aogr/202311
https://www.nxtbook.com/nxtbooks/aogr/pbios_202310
https://www.nxtbook.com/nxtbooks/aogr/202309
https://www.nxtbook.com/nxtbooks/aogr/202308
https://www.nxtbook.com/nxtbooks/aogr/202307
https://www.nxtbook.com/nxtbooks/aogr/202306
https://www.nxtbook.com/nxtbooks/aogr/202305
https://www.nxtbook.com/nxtbooks/aogr/202304
https://www.nxtbook.com/nxtbooks/aogr/202303
https://www.nxtbook.com/nxtbooks/aogr/202302
https://www.nxtbook.com/nxtbooks/aogr/202301
https://www.nxtbook.com/nxtbooks/aogr/202212
https://www.nxtbook.com/nxtbooks/aogr/202211
https://www.nxtbook.com/nxtbooks/aogr/202210
https://www.nxtbook.com/nxtbooks/aogr/202209
https://www.nxtbook.com/nxtbooks/aogr/202208
https://www.nxtbook.com/nxtbooks/aogr/202207
https://www.nxtbook.com/nxtbooks/aogr/202206
https://www.nxtbook.com/nxtbooks/aogr/202205
https://www.nxtbook.com/nxtbooks/aogr/202204
https://www.nxtbook.com/nxtbooks/aogr/202203
https://www.nxtbook.com/nxtbooks/aogr/202202
https://www.nxtbook.com/nxtbooks/aogr/202201
https://www.nxtbook.com/nxtbooks/aogr/202112
https://www.nxtbook.com/nxtbooks/aogr/202111
https://www.nxtbook.com/nxtbooks/aogr/pbios_202110
https://www.nxtbook.com/nxtbooks/aogr/202109
https://www.nxtbook.com/nxtbooks/aogr/202108
https://www.nxtbook.com/nxtbooks/aogr/202107
https://www.nxtbook.com/nxtbooks/aogr/202106
https://www.nxtbook.com/nxtbooks/aogr/202105
https://www.nxtbook.com/nxtbooks/aogr/202104
https://www.nxtbook.com/nxtbooks/aogr/202103
https://www.nxtbook.com/nxtbooks/aogr/202102
https://www.nxtbook.com/nxtbooks/aogr/202101
https://www.nxtbook.com/nxtbooks/aogr/202012
https://www.nxtbook.com/nxtbooks/aogr/202011
https://www.nxtbook.com/nxtbooks/aogr/202010
https://www.nxtbook.com/nxtbooks/aogr/202009
https://www.nxtbook.com/nxtbooks/aogr/202008
https://www.nxtbook.com/nxtbooks/aogr/202007
https://www.nxtbook.com/nxtbooks/aogr/202006
https://www.nxtbook.com/nxtbooks/aogr/202005
https://www.nxtbook.com/nxtbooks/aogr/202004
https://www.nxtbook.com/nxtbooks/aogr/202003
https://www.nxtbook.com/nxtbooks/aogr/202002
https://www.nxtbook.com/nxtbooks/aogr/202001
https://www.nxtbook.com/nxtbooks/aogr/201912
https://www.nxtbook.com/nxtbooks/aogr/201911
https://www.nxtbook.com/nxtbooks/aogr/201910
https://www.nxtbook.com/nxtbooks/aogr/201909
https://www.nxtbook.com/nxtbooks/aogr/201908
https://www.nxtbook.com/nxtbooks/aogr/201907
https://www.nxtbook.com/nxtbooks/aogr/201906
https://www.nxtbook.com/nxtbooks/aogr/201905
https://www.nxtbook.com/nxtbooks/aogr/201904
https://www.nxtbook.com/nxtbooks/aogr/201903
https://www.nxtbook.com/nxtbooks/aogr/201902
https://www.nxtbook.com/nxtbooks/aogr/201901
https://www.nxtbook.com/nxtbooks/aogr/201812
https://www.nxtbook.com/nxtbooks/aogr/201811
https://www.nxtbook.com/nxtbooks/aogr/201810
https://www.nxtbook.com/nxtbooks/aogr/pbios_201810
https://www.nxtbook.com/nxtbooks/aogr/201809
https://www.nxtbook.com/nxtbooks/aogr/201808
https://www.nxtbook.com/nxtbooks/aogr/201807
https://www.nxtbook.com/nxtbooks/aogr/201806
https://www.nxtbook.com/nxtbooks/aogr/201805
https://www.nxtbook.com/nxtbooks/aogr/201804
https://www.nxtbook.com/nxtbooks/aogr/201803
https://www.nxtbook.com/nxtbooks/aogr/201802
https://www.nxtbook.com/nxtbooks/aogr/201801
https://www.nxtbook.com/nxtbooks/aogr/201712
https://www.nxtbook.com/nxtbooks/aogr/201711
https://www.nxtbook.com/nxtbooks/aogr/201710
https://www.nxtbook.com/nxtbooks/aogr/201709
https://www.nxtbook.com/nxtbooks/aogr/201708
https://www.nxtbook.com/nxtbooks/aogr/201707
https://www.nxtbook.com/nxtbooks/aogr/201706
https://www.nxtbook.com/nxtbooks/aogr/201705
https://www.nxtbook.com/nxtbooks/aogr/201704
https://www.nxtbook.com/nxtbooks/aogr/201703
https://www.nxtbook.com/nxtbooks/aogr/201702
https://www.nxtbook.com/nxtbooks/aogr/201701
https://www.nxtbook.com/nxtbooks/aogr/201612
https://www.nxtbook.com/nxtbooks/aogr/201611
https://www.nxtbook.com/nxtbooks/aogr/201610
https://www.nxtbook.com/nxtbooks/aogr/pbios2016_programguide
https://www.nxtbook.com/nxtbooks/aogr/201609
https://www.nxtbook.com/nxtbooks/aogr/201608
https://www.nxtbook.com/nxtbooks/aogr/201607
https://www.nxtbook.com/nxtbooks/aogr/201606
https://www.nxtbook.com/nxtbooks/aogr/201605
https://www.nxtbook.com/nxtbooks/aogr/201604
https://www.nxtbook.com/nxtbooks/aogr/201603
https://www.nxtbook.com/nxtbooks/aogr/201602
https://www.nxtbook.com/nxtbooks/aogr/201601
https://www.nxtbook.com/nxtbooks/aogr/201512
https://www.nxtbook.com/nxtbooks/aogr/201511
https://www.nxtbook.com/nxtbooks/aogr/201510
https://www.nxtbook.com/nxtbooks/aogr/201509
https://www.nxtbook.com/nxtbooks/aogr/201508
https://www.nxtbook.com/nxtbooks/aogr/201507
https://www.nxtbook.com/nxtbooks/aogr/201506
https://www.nxtbook.com/nxtbooks/aogr/201505
https://www.nxtbook.com/nxtbooks/aogr/201504
https://www.nxtbook.com/nxtbooks/aogr/201503
https://www.nxtbook.com/nxtbooks/aogr/201502
https://www.nxtbook.com/nxtbooks/aogr/201501
https://www.nxtbook.com/nxtbooks/aogr/201412
https://www.nxtbook.com/nxtbooks/aogr/201411
https://www.nxtbook.com/nxtbooks/aogr/201410
https://www.nxtbook.com/nxtbooks/aogr/201409
https://www.nxtbook.com/nxtbooks/aogr/pbios2014_programguide
https://www.nxtbook.com/nxtbooks/aogr/201408
https://www.nxtbook.com/nxtbooks/aogr/201407
https://www.nxtbook.com/nxtbooks/aogr/201406
https://www.nxtbook.com/nxtbooks/aogr/201405
https://www.nxtbook.com/nxtbooks/aogr/201404
https://www.nxtbook.com/nxtbooks/aogr/201403
https://www.nxtbook.com/nxtbooks/aogr/201402
https://www.nxtbook.com/nxtbooks/aogr/201401
https://www.nxtbook.com/nxtbooks/aogr/201312
https://www.nxtbook.com/nxtbooks/aogr/201311
https://www.nxtbook.com/nxtbooks/aogr/201310
https://www.nxtbook.com/nxtbooks/aogr/201309
https://www.nxtbook.com/nxtbooks/aogr/201308
https://www.nxtbook.com/nxtbooks/aogr/201307
https://www.nxtbook.com/nxtbooks/aogr/201306
https://www.nxtbook.com/nxtbooks/aogr/201305
https://www.nxtbook.com/nxtbooks/aogr/201304
https://www.nxtbook.com/nxtbooks/aogr/201303
https://www.nxtbook.com/nxtbooks/aogr/201302
https://www.nxtbook.com/nxtbooks/aogr/201301
https://www.nxtbook.com/nxtbooks/aogr/201212
https://www.nxtbook.com/nxtbooks/aogr/201211
https://www.nxtbook.com/nxtbooks/aogr/201210
https://www.nxtbook.com/nxtbooks/aogr/201209
https://www.nxtbook.com/nxtbooks/aogr/2012_pbios
https://www.nxtbook.com/nxtbooks/aogr/201208
https://www.nxtbook.com/nxtbooks/aogr/201207
https://www.nxtbook.com/nxtbooks/aogr/201206
https://www.nxtbook.com/nxtbooks/aogr/201205
https://www.nxtbook.com/nxtbooks/aogr/201204
https://www.nxtbook.com/nxtbooks/aogr/201203
https://www.nxtbook.com/nxtbooks/aogr/201202
https://www.nxtbook.com/nxtbooks/aogr/201201
https://www.nxtbook.com/nxtbooks/demo/aogr_clone
https://www.nxtbook.com/nxtbooks/aogr/201112
https://www.nxtbookmedia.com