Dykstra Parsons Coefficient Permeability Variation Spreadsheet

X (probabilidad) Label Xlabel

Y (permeabilidad)

Ylabel Label

0.02 -2.0537489106

0

1

0.05

-1.644853627

0

10

0.10 -1.2815515655

0

0.15 -1.0364333895

0

X (probabilidad)

Xlabel Ylabel 2.5

Label Xlabel 0

0.01

Y (perm

Ylabel Label

Xlabel

-2.326347874

0

1

2.5

2.5 2.302585093

0.02 -2.0537489106

0

2

2.5

100

2.5 4.605170186

0.03 -1.8807936082 0.

0

3

2.5

1 00 000

2.5 6.907755279

0 .0 .04 -1.7506860713

0

4

2.5

0.20 -0.8416212336

0 10000

2.5 9.210340372

0 .0 .05

-1 -1.644853627

0

5

2.5

0.30 -0.5244005127

0

0.06 -1.5547735946

0

6

2 .5

0.40 -0.2533471031

0

0.07 -1.4757910282

0

7

2 .5

0.50

0

0

0.08 -1.4050715603

0

8

2.5

0.60 0.2533471031

0

0.09 -1.3407550337

0

9

2.5

0.70 0.5244005127

0

0.10 -1.2815515655

0

10 10

2 .5

0.80 0.8416212336

0

0.11

-1.22652812

0

20

2. 5

0.85 1.0364333895

0

0.12 -1.1749867921

0

30 30

2 .5

0.90 1.2815515655

0

0.13

-1.126391129

0

40

2.5

0.95

1.644853627

0

0.14 -1.0803193408

0

50

2.5

0.98 2.0537489106

0

0.15 -1.0364333895

0

60 60

2 .5

0.16 -0.9944578832

0

70

2.5

0.17 -0.9541652531

0

80

2.5

0.18 -0.9153650878

0

90

2.5

0.19 -0.8778962951

0

100

2.5

0.20 -0.8416212336

0

200

2.5

0.21

-0.806421247

0

300

2.5

0.22 -0.7721932142

0

400

2.5

0.23 -0.7388468492

0

500

2.5

0.24 -0.7063025628

0

600

2.5

0.25 -0.6744897502

0

700

2.5

0.26 -0.6433454054

0

800

2.5

0.27

-0.612812991

0

900

2.5

0.28 -0.5828415073

0

1000

2.5

0.29 -0.5533847196

0

2000

2.5

0.30 -0.5244005127

0

3000

2.5

0.31 -0.4958503473

0

4000

2.5

0.32 -0.4676987991

0

5000

2.5

0.33 -0.4399131657

0

6000

2.5

0.34 -0.4124631294

0

7000

2.5

0.35 -0.3853204664

0

8000

2.5

0.36 -0.3584587933

0

9000

2.5

0.37 -0.3318533464

0 10000

2.5

0. 3 38 8 -0. 3 30 054807881

0

0. 3 39 9 -0. 2 27 793190344

0

0. 4 40 0 -0. 2 25 533471031

0

0. 4 41 1 -0. 2 22 275449766

0

0. 4 42 2 -0. 2 20 018934791

0

0. 4 43 3 -0. 1 17 763741648

0

0. 4 44 4 -0. 1 15 509692155

0

0. 4 45 5 -0. 1 12 256613469

0

0. 4 46 6 -0. 1 10 004337205

0

0. 4 47 7 -0. 0 07 752698621

0

0. 4 48 8 -0. 0 05 501535835

0

0. 4 49 9 -0. 0 02 250689083

0

0.50

0

0

0.51 0.0250689083

0

0.52 0.0501535835

0

0.53 0.0752698621

0

0.54 0.1004337205

0

0.55 0.1256613469

0

0.56 0.1509692155

0

0.57 0.1763741648

0

0.58 0.2018934791

0

0.59 0.2275449766

0

0.60 0.2533471031

0

0.61 0.2793190344

0

0.62 0.3054807881

0

0.63 0.3318533464

0

0.64 0.3584587933

0

0.65 0.3853204664

0

0.66 0.4124631294

0

0.67 0.4399131657

0

0.68 0.4676987991

0

0.69 0.4958503473

0

0.70 0.5244005127

0

0.71 0.5533847196

0

0.72 0.5828415073

0

0.73

0.612812991

0

0.74 0.6433454054

0

0.75 0.6744897502

0

0.76 0.7063025628

0

0.77 0.7388468492

0

0.78 0.7721932142

0

0.79

0.806421247

0

0.80 0.8416212336

0

0.81 0.8778962951

0

0.82 0.9153650878

0

0.83 0.9541652531

0

0.84 0.9944578832

0

0.85 1.0364333895

0

0.86 1.0803193408

0

0.87

1.126391129

0

0.88 1.1749867921

0

0.89

1.22652812

0

0.90 1.2815515655

0

0.91 1.3407550337

0

0.92 1.4050715603

0

0.93 1.4757910282

0

0.94 1.5547735946

0

0.95

1.644853627

0

0.96 1.7506860713

0

0.97 1.8807936082

0

0.98 2.0537489106

0

0.99

0

2.326347874

 

abilidad) Ylabel 0 0.693147181 1.098612289 1.386294361 1.609437912 1.791759469 1.945910149 2.079441542 2.197224577 2.302585093 2.995732274 3.401197382 3.688879454 3.912023005 4.094344562 4.248495242 4.382026635 4.49980967 4.605170186 5.298317367 5.703782475 5.991464547 6.214608098 6.396929655 6.551080335 6.684611728 6.802394763 6.907755279 7.60090246 8.006367568 8.29404964 8.517193191 8.699514748 8.853665428 8.987196821 9.104979856 9.210340372

Layer #

Permeability (md)

1

632.5

2

Layer thikness

z

probability

Ln(k)

2.6

#VALUE!

0.00

6.450

587.5

2.6

-1.28

0.10

6.376

3

481.5

2.6

-0.84

0.20

6.177

4

447

2.6

-0.52

0.30

6.103

5

398.5

2.6

-0.25

0.40

5.988

6

217.5

2.6

0.00

0.50

5.382

7

124

2.6

0.25

0.60

4.820

8

86.5

2.6

0.52

0.70

4.460

9

79.75

2.6

0.84

0.80

4.379

10

75.35

2.6

1.28

0.90

4.322

K50 K84, !" "

207 

Dykstra-Parsons coefficient of Permeability Variation

77  0.6268  26 

   )    d   m    (   y    t    i    l    i    b   a   e   m   r   e    P

Per$ent