difference of nominal and effective decline (exponential).xls

5
Nominal a = 11% d = q = qi exp(- qn = qn-1 exp(- 0 1/1/2010 1,000 1,000 1 1 2/1/2010 896 896 2 1 3/1/2010 803 803 3 1 4/1/2010 719 719 4 1 5/1/2010 644 644 5 1 6/1/2010 577 577 6 1 7/1/2010 517 517 7 1 8/1/2010 463 463 8 1 9/1/2010 415 415 9 1 10/1/2010 372 372 10 1 11/1/2010 333 333 11 1 12/1/2010 298 298 12 1 1/1/2011 267 267 13 1 2/1/2011 239 239 14 1 3/1/2011 214 214 15 1 4/1/2011 192 192 16 1 5/1/2011 172 172 17 1 6/1/2011 154 154 18 1 7/1/2011 138 138 19 1 8/1/2011 124 124 20 1 9/1/2011 111 111 21 1 10/1/2011 99 99 22 1 11/1/2011 89 89 23 1 12/1/2011 80 80 24 1 1/1/2012 71 71 25 1 2/1/2012 64 64 26 1 3/1/2012 57 57 27 1 4/1/2012 51 51 28 1 5/1/2012 46 46 29 1 6/1/2012 41 41 30 1 7/1/2012 37 37 31 1 8/1/2012 33 33 32 1 9/1/2012 30 30 33 1 10/1/2012 27 27 34 1 11/1/2012 24 24 35 1 12/1/2012 21 21 36 1 1/1/2013 19 19 37 1 2/1/2013 17 17 38 1 3/1/2013 15 15 39 1 4/1/2013 14 14 40 1 5/1/2013 12 12 41 1 6/1/2013 11 11 42 1 7/1/2013 10 10 SUM 9,515 9,515

Upload: bilal-amjad

Post on 26-Oct-2015

31 views

Category:

Documents


1 download

DESCRIPTION

Decline Curve Analysis - Arps Decline

TRANSCRIPT

Page 1: Difference of Nominal and Effective DECLINE (EXPONENTIAL).xls

Nominala = 11% d =

q = qi exp(-at) qn = qn-1 exp(-a)0 1/1/2010 1,000 1,000 1 1 2/1/2010 896 8962 1 3/1/2010 803 8033 1 4/1/2010 719 7194 1 5/1/2010 644 6445 1 6/1/2010 577 5776 1 7/1/2010 517 5177 1 8/1/2010 463 4638 1 9/1/2010 415 4159 1 10/1/2010 372 372

10 1 11/1/2010 333 33311 1 12/1/2010 298 29812 1 1/1/2011 267 26713 1 2/1/2011 239 23914 1 3/1/2011 214 21415 1 4/1/2011 192 19216 1 5/1/2011 172 17217 1 6/1/2011 154 15418 1 7/1/2011 138 13819 1 8/1/2011 124 12420 1 9/1/2011 111 11121 1 10/1/2011 99 9922 1 11/1/2011 89 8923 1 12/1/2011 80 8024 1 1/1/2012 71 7125 1 2/1/2012 64 6426 1 3/1/2012 57 5727 1 4/1/2012 51 5128 1 5/1/2012 46 4629 1 6/1/2012 41 4130 1 7/1/2012 37 3731 1 8/1/2012 33 3332 1 9/1/2012 30 3033 1 10/1/2012 27 2734 1 11/1/2012 24 2435 1 12/1/2012 21 2136 1 1/1/2013 19 1937 1 2/1/2013 17 1738 1 3/1/2013 15 1539 1 4/1/2013 14 1440 1 5/1/2013 12 1241 1 6/1/2013 11 1142 1 7/1/2013 10 10

SUM 9,515 9,515 Q=(qi-q)/a 9001 9001

Page 2: Difference of Nominal and Effective DECLINE (EXPONENTIAL).xls

effective10.4%

qn = qn-1 (1-D) 1,000

896803719644577517463415372333298267239214192172154138124111

99898071645751464137333027242119171514121110

9,515 9505

0 5 10 15 20 25 30 35 40 45 -

200

400

600

800

1,000

1,200

q = qi exp(-at)

qn = qn-1 exp(-a)

qn = qn-1 (1-D)

Page 3: Difference of Nominal and Effective DECLINE (EXPONENTIAL).xls

0 5 10 15 20 25 30 35 40 45 -

200

400

600

800

1,000

1,200

q = qi exp(-at)

qn = qn-1 exp(-a)

qn = qn-1 (1-D)