Consolidacion PLANTILLA EXCEL

LABORATORIO DE SUELOS TOMA DE LECTURAS LECTURAS ENSAYO ENSAYO DE CONSOLIDA CONSOLIDACI CI N TIEMPO (t)

LECTURA DESPLAZAMIENTO EN PULGADAS (In.)

Minutos

Raiz de (t)

# #."# #.$5 #.5# ".## $.##

# #.$ #.5# #." ".## ".%"

%.##

$.##

'.#$

$.%5

&.#$

$.&

"".#$

.$

"5.#$

.&&

$#.#$

%.%

$5.#

5.##

#.#

5.%&

%5.#

'."

'#.#

.5

*#.#&

*.%*

"$#."$

"#.*'

"&#.##

".%$

$%#.$

"5.5#

'#.5

"&.*&

%&#.%

$".*$

$#.'&

$'.&5

*'#.*$

".##

"$#"."

%.''

"%%".

.*

"5$*.#

*.""

5 5!

"#!

$#!

%#!

&#!

"'#!

&#!

%#!

5!

0.0081 0.0083 0.0088 0.0090 0.0097 0.0104 0.0113 0.0118 0.0122 0.0126 0.0132 0.0135 0.0139 0.0140 0.0146 0.0149 0.0153 0.0156 0.0154

0.0154 0.0179 0.0181 0.0182 0.0186 0.0192 0.0200 0.0206 0.0210 0.0214 0.0219 0.0222 0.0226 0.0229 0.0235 0.0238 0.0242 0.0243 0.0244 0.0246 0.0249 0.0250 0.0251 0.0253 0.0254 0.0256 0.0256

0.0256 0.0285 0.0289 0.0295 0.0300 0.0308 0.0317 0.0324 0.0328 0.0333 0.0339 0.0345 0.0349 0.0351 0.0358 0.0361 0.0367 0.0370 0.0372 0.0375 0.0378 0.0379 0.0381 0. 0 .0383 0.0383 0.0385 0.0385

0.0385 0.0436 0.0442 0.0446 0.0454 0.0464 0.0476 0.0482 0.0488 0.0496 0.0503 0.0511 0.0517 0.0521 0.0532 0.0538 0.0545 0.0547 0.0553 0.0556 0.0557 0.0560 0.0563 0.0564 0. 0.0565 0. 0.0574 0.0574

0.0574 0.0624 0.0628 0.0633 0.0642 0.0653 0.0667 0.0678 0.0686 0.0696 0.0707 0.0717 0.0724 0.0731 0.0742 0.0747 0.0754 0.0760 0.0764 0.0767 0.0770 0.0771 0.0774 0.0775 0. 0.0777 0. 0.0778

0.0778 0.0831 0.0836 0.0842 0.0852 0.0865 0.0884 0.0899 0.0909 0.0922 0.0936 0.0947 0.0957 0.0963 0.0975 0.0984 0.0992 0.0996 0.1000 0.1003 0.1009 0.1011 0.1014 0.1017 0. 0.1018 0. 0.1020 0.1020

0.1018 0.1013 0.1011 0.1010 0.1009 0.1007 0.1006 0.1004 0.1004 0.1004 0.1003 0.1003 0.1003 0.1003 0.1003 0.1002 0.1002 0.1002 0.1002 0.1002 0.1000 0.1000 0.1000

0.0999 0.0989 0.0986 0.0984 0.0979 0.0972 0.0966 0.0960 0.0957 0.0949 0.0949 0.0945 0.0943 0.0940 0.0938 0.0936 0.0935 0.0934 0.0932 0.0931 0.0929 0.0928 0.0928 0.0928

0.0927 0.0921 0.0918 0.0915 0.0912 0.0906 0.0896 0.0890 0.0885 0.0878 0.0870 0.0861 0.0853 0.0847 0.0834 0.0822 0.0807 0.0796 0.0781 0.0774 0.0763 0.0760 0.0000 0.0000

O+SER,ACIONES-

4 0.5

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

O+SER,ACIONES-

4 0.5

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

DIMENSIONES DE LA MUESTRA INICIAL Diámetro, D (cm.) 4.913 Altura, H (cm.) (cm.) 1.904 W.Anillo (gr.) 61.6 W.Anillo + Muetra (gr.) 101.56 W.!lo"u#.+ $.%oroa (gr.) 3&'.13

INAL

133.1

/UMEDAD NATURA TURAL L

eci%iente o

INA INAL L

1

&

W.m. Hum + ec. (gr.).

144.10

101.65

W.m *eca + ec. (gr.).

1&3.40

''.'0

W.r (gr.).

3'.50

3&.43

Humea. ()

24.4

PESO ESPECIICO DEL SUELO °C

-em%eratura el enao (T)

22.8

A

W.$ic.+ agua tem% -/ (0a) (0a)

gr.

14&.&1

W.$ic+Muetra+agua (01)

gr.

15'.64

gr.

&6.4'

gr/cm3

2.601

$eo Muetra *eca (0o) *eca (0o) $eo e%eciico uelo (Gs)

0.2047 0.2117 0.2223 0.2294 0.2470 0.2646 0.2858 0.2999 0.3105 0.3211 0.3352 0.3423 0.3529 0.3564 0.3705 0.3776 0.3881 0.3952 0.3917

0.3917 0.4552 0.4587 0.4622 0.4728 0.4869 0.5081 0.5222 0.5328 0.5434 0.5575 0.5646 0.5752 0.5822 0.5963 0.6034 0.6140 0.6175 0.6210 0.6246 0.6316

0.6493 0.7234 0.7339 0.7481 0.7622 0.7833 0.8045 0.8222 0.8327 0.8469 0.8610 0.8751 0.8857 0.8927 0.9104 0.9174 0.9315 0.9386 0.9457 0.9527 0.9598

0.9774 1.1080 1.1221 1.1327 1.1538 1.1785 1.2086 1.2244 1.2385 1.2597 1.2773 1.2985 1.3126 1.3232 1.3514 1.3656 1.3832 1.3903 1.4044 1.4114 1.4150

DIMENSIONES DE LA MUESTRA INICIAL Diámetro, D (cm.) 4.913 Altura, H (cm.) (cm.) 1.904 W.Anillo (gr.) 61.6 W.Anillo + Muetra (gr.) 101.56 W.!lo"u#.+ $.%oroa (gr.) 3&'.13

INAL

133.1

/UMEDAD NATURA TURAL L

eci%iente o

INA INAL L

1

&

W.m. Hum + ec. (gr.).

144.10

101.65

W.m *eca + ec. (gr.).

1&3.40

''.'0

W.r (gr.).

3'.50

3&.43

Humea. ()

24.4

PESO ESPECIICO DEL SUELO °C

-em%eratura el enao (T)

22.8

A

W.$ic.+ agua tem% -/ (0a) (0a)

gr.

14&.&1

W.$ic+Muetra+agua (01)

gr.

15'.64

$eo Muetra *eca (0o) *eca (0o)

gr.

&6.4'

gr/cm3

2.601

$eo e%eciico uelo (Gs)

DESCARGA 160 A '0 4013 '0 A 40 3'9' 40 A 5 394 5A0 3699

0.2047 0.2117 0.2223 0.2294 0.2470 0.2646 0.2858 0.2999 0.3105 0.3211 0.3352 0.3423 0.3529 0.3564 0.3705 0.3776 0.3881 0.3952 0.3917

0.0 '.0 9.5 10.& 1&.& 1&.9 14.5 16.0 1.4 19.3 &&.4 . &'.4 31.5 35.4 3.3 3'.6 39. 40.& 40. 4& 0

0.3917 0.4552 0.4587 0.4622 0.4728 0.4869 0.5081 0.5222 0.5328 0.5434 0.5575 0.5646 0.5752 0.5822 0.5963 0.6034 0.6140 0.6175 0.6210 0.6246 0.6316 0.6351 0.6387 0.6422 0.6457 0.6493 0.6493

0.65 0 5.& 6.15 6.63 .93 '.3'5 9.4&5 10.4 11.31 1&.545 14.56 . 1'.46 &0.45 &3.01 &4.&45 &5.09 &5.'05 &6.13 &6.455 & 3

0.6493 0.7234 0.7339 0.7481 0.7622 0.7833 0.8045 0.8222 0.8327 0.8469 0.8610 0.8751 0.8857 0.8927 0.9104 0.9174 0.9315 0.9386 0.9457 0.9527 0.9598 0.9633 0.9668 0.9739 0.9739 0.9774 0.9774

0.9774 1.1080 1.1221 1.1327 1.1538 1.1785 1.2086 1.2244 1.2385 1.2597 1.2773 1.2985 1.3126 1.3232 1.3514 1.3656 1.3832 1.3903 1.4044 1.4114 1.4150 1.4220 1.4291 1.4326 1.4361 1.4573 1.4573

DESCARGA 160 A '0 4013 '0 A 40 3'9' 40 A 5 394 5A0 3699

0.65 0 5.& 6.15 6.63 .93 '.3'5 9.4&5 10.4 11.31 1&.545 14.56 . 1'.46 &0.45 &3.01 &4.&45 &5.09 &5.'05 &6.13 &6.455 &.3

0.0 '.0 9.5 10.& 1&.& 1&.9 14.5 16.0 1.4 19.3 &&.4 . &'.4 31.5 35.4 3.3 3'.6 39. 40.& 40. 4&.0

1.4573 1.5843 1.5949 1.6090 1.6302 1.6584 1.6937 1.7219 1.7431 1.7678 1.7960 1.8207 1.8384 1.8560 1.8843 1.8984 1.9160 1.9301 1.9407 1.9478 1 9548

1.9760 2.1101 2.1242 2.1383 2.1630 2.1983 2.2442 2.2830 2.3077 2.3430 2.3783 2.4065 2.4312 2.4453 2.4771 2.4982 2.5194 2.5300 2.5406 2.5476 2 5618

2.5865 2.5723 2.5688 2.5653 2.5618 2.5582 2.5547 2.5512 2.5512 2.5512 2.5476 2.5476 2.5476 2.5476 2.5476 2.5441 2.5441 2.5441 2.5441 2.5441 2 5406

2.5371 2.5124 2.5053 2.4982 2.4876 2.4700 2.4524 2.4382 2.4312 2.4117 2.4100 2.3994 2.3959 2.3888 2.3818 2.3783 2.3747 2.3712 2.3677 2.3641 2 3606

2.3536 2.3394 2.3324 2.3253 2.3174 2.3006 2.2759 2.2618 2.2477 2.2301 2.2089 2.1877 2.1665 2.1524 2.1171 2.0889 2.0501 2.0219 1.9831 1.9654 1 9372

1.4573 1.5843 1.5949 1.6090 1.6302 1.6584 1.6937 1.7219 1.7431 1.7678 1.7960 1.8207 1.8384 1.8560 1.8843 1.8984 1.9160 1.9301 1.9407 1.9478 1.9548 1.9584 1.9654 1.9689 1.9725 1.9760

1.9760 2.1101 2.1242 2.1383 2.1630 2.1983 2.2442 2.2830 2.3077 2.3430 2.3783 2.4065 2.4312 2.4453 2.4771 2.4982 2.5194 2.5300 2.5406 2.5476 2.5618 2.5688 2.5759 2.5829 2.5865 2.5900 2.5900

2.5865 2.5723 2.5688 2.5653 2.5618 2.5582 2.5547 2.5512 2.5512 2.5512 2.5476 2.5476 2.5476 2.5476 2.5476 2.5441 2.5441 2.5441 2.5441 2.5441 2.5406 2.5406 2.5406

2.5371 2.5124 2.5053 2.4982 2.4876 2.4700 2.4524 2.4382 2.4312 2.4117 2.4100 2.3994 2.3959 2.3888 2.3818 2.3783 2.3747 2.3712 2.3677 2.3641 2.3606 2.3571 2.3571 2.3571

2.3536 2.3394 2.3324 2.3253 2.3174 2.3006 2.2759 2.2618 2.2477 2.2301 2.2089 2.1877 2.1665 2.1524 2.1171 2.0889 2.0501 2.0219 1.9831 1.9654 1.9372 1.9301

DATOS DATOS INICIALES Y FINALES Diametro Interior Anillo, f (cm) Alt, Anillo= Alt, muetra, ! (cm) "eo #el Anillo, $a (%) &elacion #el 'rao "eo uetra * Anillo, $ma (%) Inicial "eo "ie#ra "or, * 'l+, $a (%) "eo -eci/co #e oli#o  "eo uetra * Anillo, $ma (%) inal

4.913 1.904 61.6 101.56 290.6 2.601 133.1

INDICE

HORA

ESPLAZAMIENT (in)

HORA

0 1 2 3 4 5 6 7

00000 00006 00015 00030 00100 00200 00400 00601

0.2047 0.2117 0.2223 0.2294 0.2470 0.2646 0.2858 0.2999

00000 00006 00015 00030 00100 00200 00400 00601

10 kg ESPLAZAMIENT (in) 0.3917 0.4552 0.4587 0.4622 0.4728 0.4869 0.5081 0.5222

DATOS DATOS INICIALES Y FINALES Diametro Interior Anillo, f (cm) Alt, Anillo= Alt, muetra, ! (cm) "eo #el Anillo, $a (%) &elacion #el 'rao "eo uetra * Anillo, $ma (%) Inicial "eo "ie#ra "or, * 'l+, $a (%) "eo -eci/co #e oli#o  "eo uetra * Anillo, $ma (%) inal

INDICE

HORA

ESPLAZAMIENT (in)

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

00000 00006 00015 00030 00100 00200 00400 00601 00801 001101 01501 02001 02502 03002 04503 10004 13005 20007 25052

0.2047 0.2117 0.2223 0.2294 0.2470 0.2646 0.2858 0.2999 0.3105 0.3211 0.3352 0.3423 0.3529 0.3564 0.3705 0.3776 0.3881 0.3952 0.3917

4.913 1.904 61.6 101.56 290.6 2.601 133.1

HORA 00000 00006 00015 00030 00100 00200 00400 00601 00801 01101 01501 02001 02502 03002 04503 10004 13005 20007 30011 40014 60021 80028 120041 160055 200108 240122 252942

10 kg ESPLAZAMIENT (in) 0.3917 0.4552 0.4587 0.4622 0.4728 0.4869 0.5081 0.5222 0.5328 0.5434 0.5575 0.5646 0.5752 0.5822 0.5963 0.6034 0.6140 0.6175 0.6210 0.6246 0.6316 0.6351 0.6387 0.6422 0.6457 0.6493 0.6493

CONTENIDO DE HUMEDAD (") DA "eo muetra :ume#a * reciiente (%) "eo muetra eca * reciiente (%) "eo reciiente (%)  ; (<) Inicial  ; (<) inal

IIIA 144.1 123.4 38.5

20 kg ESPLAZAMIENT (in)

0 kg ESPLAZAMIENT (in)

!0 kg ESPLAZAMIENT (in)

10 kg ESPLAZAMIENT (in)

0.6493 0.7234 0.7339 0.7481 0.7622 0.7833 0.8045 0.8222 0.8327 0.8469 0.8610 0.8751 0.8857 0.8927 0.9104 0.9174 0.9315 0.9386 0.9457 0.9527 0.9598 0.9633 0.9668 0.9739 0.9739 0.9774 0.9774

0.9774 1.1080 1.1221 1.1327 1.1538 1.1785 1.2086 1.2244 1.2385 1.2597 1.2773 1.2985 1.3126 1.3232 1.3514 1.3656 1.3832 1.3903 1.4044 1.4114 1.4150 1.4220 1.4291 1.4326 1.4361 1.4573 1 1.4573

1.4573 1.5843 1.5949 1.6090 1.6302 1.6584 1.6937 1.7219 1.7431 1.7678 1.7960 1.8207 1.8384 1.8560 1.8843 1.8984 1.9160 1.9301 1.9407 1.9478 1.9548 1.9584 1.9654 1.9689 1.9725 1.9760

1.9760 2.1101 2.1242 2.1383 2.1630 2.1983 2.2442 2.2830 2.3077 2.3430 2.3783 2.4065 2.4312 2.4453 2.4771 2.4982 2.5194 2.5300 2.5406 2.5476 2.5618 2.5688 2.5759 2.5829 2.5865 2.5900 2.5900

IA 101.65 88.8 32.43

!0 kg ESP ESPLAZAMIENT (in)

0 kg ESPLAZAMIENT (in)

2.5865 2.5723 2.5688 2.5653 2.5618 2.5582 2.5547 2.5512 2.5512 2.5512 2.5476 2.5476 2.5476 2.5476 2.5476 2.5441 2.5441 2.5441 2.5441 2.5441 2.5406 2.5406 2.5406

2.5371 2.5124 2.5053 2.4982 2.4876 2.4700 2.4524 2.4382 2.4312 2.4117 2.4100 2.3994 2.3959 2.3888 2.3818 2.3783 2.3747 2.3712 2.3677 2.3641 2.3606 2.3571 2.3571 2.3571

# kg ESP ESPLAZAMIEN IENTO (in) 2.3536 2.3394 2.3324 2.3253 2.3174 2.3006 2.2759 2.2618 2.2477 2.2301 2.2089 2.1877 2.1665 2.1524 2.1171 2.0889 2.0501 2.0219 1.9831 1.9654 1.9372 1.9301

AA&AD-

) n i " # # # 2 # ( L A I D L E D A R U T C E L

LECTURA DEL DEL DIAL #2###" 3s LOGARITM O DEL DEL TIEMPO T IEMPO (M ( M ETODO DE DE CASAGRANDE) CASAGRANDE) $0&0'0(% 0.00'0

5 4! 0.0090


L EC EC TU TURA DE DEL DI DIAL #2 #2## #" #" 3s 3s L OG OGA RI RIT M O DEL TI TIEM PO PO (

#0=0,0172

0.010

0.0190

0.0100

$#0&0'020( 0.0110

0.0&10

$#0&0'011( 0.01&0

0.0&30

$%0&0'02*#

0.0130

#100=0,0242 0.0140 0.0&50

$%0&0'01#21# 0.0150

#100=0,0156 0.0160 1

0

1 LOGARITMO DEL TIEMPO

) n i " # # # 2 # ( LECTURA L A I D L 0.0400 E D A R U 0.04&0 T #0=0,0432 C E L 0.0440

% ' " & 0 # )

0 0 1

0 % & 0 % )

0.0&0 1 0 0 0 1

DEL DEL DIAL #2###" #2## #" 3s LOGARITM O DE DEL T IEMPO (M ETODO DE CASAGRANDE CA SAGRANDE)

%# 4!

0 1

LOGARITMO DEL ) n i " # # # 2 # ( LECTURA LECTURA L A I D L 0.0600 E D #0=0,0612 A R 0.06&0 U T C E L 0.0640

2 ' " & 0 # TIEMPO )

! 

& 0 0 0 1 % )

DEL DEL DIAL #2 ###" 3s LOGARITM O DE DEL T IEM IEM PO

0.0660 0.0460 0.06'0

$#0&0'0"!"

0.04'0 $#0&0'0%

0.000

0.0500

0.0&0

0.05&0

$%0&0'0# 0.0540

0.040 $%0&0'0(#

#100=0,0549

#100=0,076 0.060

0.0560

0.0'0

0.05'0

0.0600 1

0 1

LOGARITMO DEL


# ' ! & 0 # ) TIEMPO

0 0 1

# " & 0 % )

LECTURA DEL DIAL #2###" 3s LOGARITMO DEL TIEMPO (METODO DE CASAGRANDE) &'00.0000

## 4!

3300.0000

3'00.0000

4300.0000

4'00.0000

5300.0000

0.0'00 0 0 0 1

0 0 0 0 1

1

0 1

% & 0 # )

LOGARITMO DEL TIEMPO

0 0 1

 ( & 0 % )

AA&AD.

5'00.0000 1

0 1

0 0 1

LOGARITMO LOGARITMO DEL TIEMPO

0 0 0 1

0 0 0 0 1

AA&AD-

) n i " # # # 2 # ( LECTURA L A I D L 0.0&0 E D A #0=0,0283 R U T C 0.0&90 E L

M ETODO DE CA SAGRANDE) SAGRANDE)

"# 4!

DEL DEL DIAL #2###" 3s LOGARITM O DEL DEL T IEM IEM PO (M ETODO DE DE CASAGRANDE CASAGRANDE))

$# 4!

0.0310

$#0&0'0*2! 0.0330

0.0350

$%0&0'0*"*

#100=0,0372 0.030

0.0390

0 0 0 1

1

0 0 0 0 1

(M ETODO DE CA SAGRANDE) SAGRANDE)

&# 4!

0 1

! & 0 # )

LOGARITMO DEL TIEMPO ) n i " # # # 2 # ( LECTURA L A I D L 0.0'00 E #0=0,0819 D A R 0.0'&0 U T C E 0.0'40 L

0 0 1

0 ( & 0 % )

0 0 0 1

0 0 0 0 1

DEL DIAL #2### " 3s LOGARITM O DEL TIEMPO T IEMPO (M ETODO DE DE CASAGRAN CA SAGRANDE DE))

"'# 4!

0.0'60

0.0''0

$#0&0'0%

0.0900

0.09&0

0.0940

0.0960

$%0&0'0%(# 0.09'0

#100=0,0993 0.1000

0.10&0

0.1040 0 0 0 1

0 0 0 0 1

1

0 1

" & 0 # )

LOGARITMO DEL TIEMPO

0 0 1

2  & 0 % )

0 0 0 1

0 0 0 0 1

AA&AD-

H (+,) H.2 (+,)

CAR/A # 10 20 0 !0 10

1-%0 0-%#2

$#0 0.0117 0. 0.0207 0. 0.0328 0. 0 .049 0. 0.0686 0.09

T#0 T%0

#0 6.9 6.2 8 8.5 9 6

C #0 (+,2.) 0-0002%!* 0-000!* 0-000*0*1 0-000*!%22 0-000*2%#1 0-000%*122

0-1%*%# 0-!#1

$%0 0.1522 0.0235 0.0363 0.054 0.0745 0.0975

%0 90 48 70 65 74 42

C %0 (+,2.) 0-00012!2! 0-0002!002 0-0001!**# 0-0001%02 0-0001*0!* 0-000*00#

C34g3

A A&

) n i " # # # 2 # ( L LECTURA A I D L 0.000 E D A $0&0'00(% R U T 0.00'5 C A L

) n i " # # # 2 # ( L A I D L E D

DEL DEL DIAL 3s RAIZ DEL DEL T IEMP IEMP O (M ETODO ETODO DE TA LOR)

54!

L EC EC T UR URA DE DEL DI DI AL AL 3s 3s RA RA IZ IZ DE DEL T IE IE 0.0160

A R U T $0&0'01("! C A 0.01'0 L

$#0&0'01012 0.0100

0.0&00

$#0&0'020#!

0.0115 $%0&0'011%

0.0&&0

0.0130

$%0&0'022% 0.0145 0.0&40

0.0160

0.0&60   1 ' 1 & 0 # )

0

#

2 & '

) n i " # # # 2 # ( L LECTURA A I D L 0.04&0 E D $0&0'0** A R U T 0.0445 C A L

" & 0 % )

3

4

5

6



'

9

10

11 11

1& 1&

13 13

14 14

# 2 ' " & 0 # )

0

15 15

RAIZ DE (t )

) n i " # # # 2 # ( L L EC EC TU TURA A I D L 0.0610 E $0&0'0"1! D

DEL DEL DIAL 3 s RAIZ DEL DEL T IEMPO (M ETODO DE DE TA LOR)

%#4!

A R U T C A L

0.040 $#0&0'((

" # ( ' # 2 & 0 % )

10

DE DEL DI DIA L 3s RA RA IZ DE DEL TI TI

0.0640

$#0&0'0"( 0.060

0.0495 0.000

$%0&0'0#12 0.05&0

$%0&0'0(1% 0.030

0.0545

0.060 0.050

0

) n i " # # # 2 # ( L A I D L E D A R U T C A L

%  ' ! 1 & 0 % )

1  '  & 0 # )

0.090 6

1&

1'

&4

RAIZ DE (t)

LECTURA DEL DIAL 3s RAIZ DEL TIEMPO (METODO DE TA5LOR)

"'2##4!678 $

&'30.0000

3330.0000

3'30.0000

4330.0000

4'30.0000

5330.0000

5'30.0000 0

10

&0

30

RAIZ DE (t)

40

50

30

36

4&

0

 ! '  & 0 # )

 0

4 '

* 2 & 0 % )

'

1&

A A& &

) n i " # # # 2 # ( L A I D L E D

PO (M ETODO DE TAL OR)

"#4!

LECTURA DEL DEL DIAL 3s RAIZ DEL DEL T IEM IEM PO (M ETODO DE DE TALOR)

$#4!

0.0&50

A R U T C $0&0'02!2 A L

0.0300 $#0&0'0*!*

$%0&0'0*2%

0.0350

0.0400 &0

30

40

% % ! &

0. 00 ' 0

10. 00

2 % & ) 0 # )

RAIZ DE (t)

) n i " # # # 2 # ( L LECTURA A I D L 0.0'10 E D $0&0'0!2

EMPO (M ETODO ETODO DE TA LOR)

!

A R U T C A L

&0. 00

30. 00

RAIZ DE (t )

DEL DEL DIAL 3s RAIZ DEL TIEMPO ( M ETODO ETODO DE TAL OR)

"'#4

0.0'30

0.0'50

0.0'0

0.0'90 $#0&0'0!%( 0.0910

0.0930

0.0950 $%0&0'0%#" 0.090

0.0990

0.1010

0.1030

16

&0

RAIZ DE (t)

&4

&'

3&

36

40

0

# 2 ' * & 0 # )

1

0 4 '

" 2 & 0 % )

'

1&

16

&0

RAIZ DE (t)

&4

&'

3&

3

A A&

40.00

40

H (+,) H.2 (+,)

CAR/A # 10 20 0 !0 10

1-%0 0-%#2

$#0 0.01012 0.01012 0.02058 0.02058 0.03 0.0383 83 0.04 0.0477 77 0.06 0.0674 74 0.08 0.0897 97

T#0 T%0

#0 C #0 (+,2.) 1.44 0-0020#%* 6.25 0-000#*% 2.89 2.89 0-001022#* 4.41 4.41 0-0002#**# 4.84 4.84 0-00012!* 3.25 3.25 0-000%12#*

0-1%*%#1 0-!#1

$%0 0.0119 0.0229 0.0329 0.0512 0.0719 0.0956

%0 6.25 25.756 9 18.49 23.04 26.01

C %0 (+,2.) 0-0020#0#% 0-000%%0!2 0-0012!2! 0-000%#20!% 0-000##%12 0-000%210

C34g3

ENSAYO DE CONSOLIDACIÓN RÁPIDA INVIAS E-152 "&- IIA- D-&I"I?

D- >-&A "&.(m)

DI-I- D- AI A>&A 1.904 cm DI-& 4.913 cm &-A 18.96 cmB

"eo >nitario Lt

'

1.107 %Ccm3

CONTENIDO DE HUMEDAD "- D- A >>-&A &A Inic Inicia iall "eo anillo*muetra :um. % 101.56 "eo eo anil anillo lo*m *mue uet tra ra eca eca.. % 93.7 93.73 3 "eo anillo % 61.60 "eo #el a%ua $ 7.83 "eo uelo eco @ 32.13 !ume#a# @ 24.38 ar%a Alica#a (J%CcmB) 0.00 0.26 0.53 1.06 2.11 4.22 8.44 4.22 2.11 0.26

ectura inal (l%.) 0 0.0154 0.0256 0.0385 0.0574 0.0778 0.1020 0.1000 0.0928 0.0760

oe/ciente #e comrein c oe/ciente #e e;anHon  &elacin #e GacHo inicial &elacin #e GacHo /nal "rein #e reconoli#acin  "c oKerGacione

&AD D- A>&AI? @ Inicial 100 inal 100

0.75 l%. 1.93 l%.

2.601

$ Altura #e li#o, 2!=

ina inal 133.10 107. 107.88 88 61.60 25.22 46.28 54.49

2! (l%.) 0.7496 0.7342 0.7240 0.7111 0.6922 0.6718 0.6476 0.6496 0.6568 0.6736

 

=

0.6516 cm

0.2565

l%.

EDFEA 

2!  2!

e=

, ) 6 (

2!

Altura GacHo (l%.) 2!  2! 0.4931 0.4777 0.4675 0.4546 0.4357 0.4153 0.3911 0.3931 0.4003 0.4171

0.802 0.094 1.9222 1.5247 1.69

2 ; : + 3 9

&elacin #e acHo

6 $

1.9000

n 8 i + 1.8500 3 7 6 R1.8000

e

1.9222 1.8621 1.8226 1.7722 1.6985 1.6189 1.5247 1.5323 1.5604 1.6260

1.7500 1.7000 1.6500 1.6000 1.5500

J% C cmB

1.5000 0.10

0.1310596776 0.1264250414 0.1197963836 0.1048586785

MP=1'"% ESFUERZ kg . + 1.O 00 kg

A

A

1

5

10.00

min

in # #."# #.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.#

0.0081 0.0083 0.0088 0.0090 0.0097 0.0104 0.0113 0.0118 0.0122 0.0126 0.0132 0.0135 0.0139 0.0140 0.0146 0.0149

o . m e i t l e n e o t n e C< 40 i m a t 0 10 0 0 n e 0.0000  A

0.0200 0.0400 0.0600

min

in

# #."# #.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.##

180.00 180.00 180.10 180.10 180.25 180.25 180.50 180.50 181.00 181.00 182.00 182.00 184.00 184.00 186.02 186.02 188.02 188.02 191. 191.02 02 195.02 195.02 200.02 200.02 205.03 205.03 210.03 210.03 225.03 225.03 240.07 240.07 270.08 270.08 300.12 300.12 360.00 360.00 420.23 420.23 540.35 540.35 660.47 660.47 900.68 900.68 1140.92 1140.92 1381.13 1381.13 1621.37 1621.37 1709.70 1709.70 1709 1709.7 .70 0 1709 1709.8 .80 0 1709 1709.9 .95 5

0.0081 0.0083 0.0088 0.0090 0.0097 0.0104 0.0113 0.0118 0.0122 0.0126 0.0132 0.0135 0.0139 0.0140 0.0146 0.0149 0.0153 0.0156 0.0154 0.01542 0.01542126 126 0.01792 0.01792126 126 0.01805 0.01805906 906 0.01819 0.01819685 685 0.01861 0.01861417 417 0.01916 0.01916929 929 0.02000 0.02000394 394 0.02055 0.02055906 906 0.02097 0.02097638 638 0.02 0.0213 1393 937 7 0.02194 0.02194882 882 0.02222 0.02222835 835 0.02264 0.02264567 567 0.02292 0.02292126 126 0.02347 0.02347638 638 0.02375 0.02375591 591 0.02417 0.02417323 323 0.02431 0.02431102 102 0.02444 0.02444882 882 0.02459 0.02459055 055 0.02486 0.02486614 614 0.02500 0.02500394 394 0.02514 0.02514567 567 0.02528 0.02528346 346 0.02542 0.02542126 126 0.02556 0.02556299 299 0.02556 0.02556299 299 0.02 0.0256 56 0.02 0.0285 85 0.02 0.0289 89

o . m e i t l e n e o t n e C< 40 i m a t 0 10 0 0 n e 0.0000  A

0.0200 0.0400 0.0600 0.0800 0.1000

# #."# #.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.% $#.'& *'#.*$ "$#"." "%%". "5$*.# # #."# #.$5

1710 1710.2 .20 0 0.02 0.0295 95 1710 1710.7 .70 0 0.03 0.0300 00 1711 1711.7 .70 0 0.03 0.0308 08 1713 1713.7 .70 0 0.03 0.0317 17 1715 1715.7 .72 2 0.03 0.0324 24 1717 1717.7 .72 2 0.03 0.0328 28 1720 1720.7 .72 2 0.03 0.0333 33 1724 1724.7 .72 2 0.03 0.0339 39 1729 1729.7 .72 2 0.03 0.0345 45 1734 1734.7 .73 3 0.03 0.0349 49 1739 1739.7 .73 3 0.03 0.0351 51 1754 1754.7 .73 3 0.03 0.0358 58 1769 1769.7 .77 7 0.03 0.0361 61 1799 1799.7 .78 8 0.03 0.0367 67 1829 1829.8 .82 2 0.03 0.0370 70 1889 1889.7 .70 0 0.03 0.0372 72 1949 1949.9 .93 3 0.03 0.0375 75 2070 2070.0 .05 5 0.03 0.0378 78 2190 2190.1 .17 7 0.03 0.0379 79 2430 2430.3 .38 8 0.03 0.0381 81 2670 2670.6 .62 2 0.03 0.0383 83 2910 2910.8 .83 3 0.03 0.0383 83 3151 3151.0 .07 7 0.03 0.0385 85 3239 3239.4 .40 0 0.03 0.0385 85 3239 3239.4 .40 0 0.03 0.0385 85 3239 3239.5 .50 0 0.04 0.0436 36 3239 3239.6 .65 5 0.04 0.0442 42 3239 3239.9 .90 0 0.04 0.0446 46 3240 3240.4 .40 0 0.04 0.0454 54 3241 3241.4 .40 0 0.04 0.0464 64 3243 3243.4 .40 0 0.04 0.0476 76 3245 3245.4 .42 2 0.04 0.0482 82 3247 3247.4 .42 2 0.04 0.0488 88 3250 3250.4 .42 2 0.04 0.0496 96 3254 3254.4 .42 2 0.05 0.0503 03 3259 3259.4 .42 2 0.05 0.0511 11 3264 3264.4 .43 3 0.05 0.0517 17 3269 3269.4 .43 3 0.05 0.0521 21 3284 3284.4 .43 3 0.05 0.0532 32 3299 3299.4 .47 7 0.05 0.0538 38 3329 3329.4 .48 8 0.05 0.0545 45 3359 3359.5 .52 2 0.05 0.0547 47 3419 3419.4 .40 0 0.05 0.0553 53 3479 3479.6 .63 3 0.05 0.0556 56 3599 3599.7 .75 5 0.05 0.0557 57 3719 3719.8 .87 7 0.05 0.0560 60 3960 3960.0 .08 8 0.05 0.0563 63 4200 4200.3 .32 2 0.05 0.0564 64 4440 4440.5 .53 3 0.05 0.0565 65 4680 4680.7 .77 7 0.05 0.0574 74 4769 4769.1 .10 0 0.05 0.0574 74 4769.10 4769.10 0.05737 0.05737402 402 4769.20 4769.20 0.06237 0.06237402 402

#.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.% $#.'& *'#.*$ "$#"." "%%". "5$*.# # #."# #.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.% $#.'& *'#.*$ "$#"." "%%". "5$*.# # #."#

4769.35 4769.35 4769.60 4769.60 4770 4770.10 .10 4771.10 4771.10 4773 4773.10 .10 4775.12 4775.12 4777.12 4777.12 4780.12 4780.12 4784.12 4784.12 4789 4789.12 .12 4794.13 4794.13 4799.13 4799.13 4814.13 4814.13 4829.17 4829.17 4859.18 4859.18 4889.22 4889.22 4949.10 4949.10 5009.33 5009.33 5129.45 5129.45 5249.57 5249.57 5489.78 5489.78 5730.02 5730.02 5970.23 5970.23 6210.47 6210.47 6210 6210.4 .47 7 6210 6210.5 .57 7 6210 6210.7 .72 2 6210 6210.9 .97 7 6211 6211.4 .47 7 6212 6212.4 .47 7 6214 6214.4 .47 7 6216 6216.4 .48 8 6218 6218.4 .49 9 6221 6221.4 .49 9 6225 6225.4 .49 9 6230 6230.4 .49 9 6235 6235.5 .50 0 6240 6240.5 .50 0 6255 6255.5 .50 0 6270 6270.5 .53 3 6300 6300.5 .55 5 6330 6330.5 .58 8 6390 6390.4 .47 7 6450 6450.7 .70 0 6570 6570.8 .82 2 6690 6690.9 .93 3 6931 6931.1 .15 5 7171 7171.3 .38 8 7411 7411.6 .60 0 7651 7651.8 .83 3 7740 7740.1 .17 7 7740.17 7740.17 7740.27 7740.27

0.06279 0.06279134 134 0.06334 0.06334646 646 0.064 0.06418 1811 11 0.06529 0.06529134 134 0.066 0.06668 6811 11 0.06779 0.06779134 134 0.06862 0.06862598 598 0.06959 0.06959843 843 0.07070 0.07070866 866 0.071 0.07168 6811 11 0.07237 0.07237795 795 0.07307 0.07307087 087 0.07418 0.07418504 504 0.07474 0.07474016 016 0.07543 0.07543307 307 0.07598 0.07598819 819 0.07640 0.07640551 551 0.07668 0.07668504 504 0.07696 0.07696063 063 0.07710 0.07710236 236 0.07737 0.07737795 795 0.07751 0.07751575 575 0.07765 0.07765748 748 0.07779 0.07779528 528 0.07 0.0778 78 0.08 0.0831 31 0.08 0.0836 36 0.08 0.0842 42 0.08 0.0852 52 0.08 0.0865 65 0.08 0.0884 84 0.08 0.0899 99 0.09 0.0909 09 0.09 0.0922 22 0.09 0.0936 36 0.09 0.0947 47 0.09 0.0957 57 0.09 0.0963 63 0.09 0.0975 75 0.09 0.0984 84 0.09 0.0992 92 0.09 0.0996 96 0.10 0.1000 00 0.10 0.1003 03 0.10 0.1009 09 0.10 0.1011 11 0.10 0.1014 14 0.10 0.1017 17 0.10 0.1018 18 0.10 0.1020 20 0.10 0.1020 20 0.10183 0.10183071 071 0.10127 0.10127165 165

#.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.% $#.'& *'#.*$ "$#"." "%%". # #."# #.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.% $#.'& *'#.*$ "$#"." "%%". "5$*.# # #."#

7740.42 7740.42 7740.67 7740.67 7741.17 7741.17 7742.17 7742.17 7744.17 7744.17 7746.18 7746.18 7748.19 7748.19 7751.19 7751.19 7755.19 7755.19 7760.19 7760.19 7765.20 7765.20 7770.20 7770.20 7785.20 7785.20 7800.23 7800.23 7830.25 7830.25 7860.28 7860.28 7920.17 7920.17 7980.40 7980.40 8100.52 8100.52 8220.63 8220.63 8460.85 8460.85 8460 8460.8 .85 5 8460 8460.9 .95 5 8461 8461.1 .10 0 8461 8461.3 .35 5 8461 8461.8 .85 5 8462 8462.8 .85 5 8464 8464.8 .85 5 8466 8466.8 .87 7 8468 8468.8 .87 7 8471 8471.8 .87 7 8475 8475.8 .87 7 8480 8480.8 .87 7 8485 8485.8 .88 8 8490 8490.8 .88 8 8505 8505.8 .88 8 8520 8520.9 .92 2 8550 8550.9 .93 3 8580 8580.9 .97 7 8640 8640.8 .85 5 8701 8701.0 .08 8 8821 8821.2 .20 0 8941 8941.3 .32 2 9181 9181.5 .53 3 9421 9421.7 .77 7 9421.77 9421.77 9421.87 9421.87 9422.02 9422.02 9422.27 9422.27 9422.77 9422.77 9423 9423.77 .77 9425.77 9425.77 9427.78 9427.78

0.10113 0.10113386 386 0.10099 0.10099606 606 0.10085 0.10085827 827 0.10071 0.10071654 654 0.10057 0.10057874 874 0.10044 0.10044094 094 0.10044 0.10044094 094 0.10044 0.10044094 094 0.10029 0.10029921 921 0.10029 0.10029921 921 0.10029 0.10029921 921 0.10029 0.10029921 921 0.10029 0.10029921 921 0.10016 0.10016142 142 0.10016 0.10016142 142 0.10016 0.10016142 142 0.10016 0.10016142 142 0.10016 0.10016142 142 0.10002 0.10002362 362 0.10002 0.10002362 362 0.10002 0.10002362 362 0.09 0.0999 99 0.09 0.0989 89 0.09 0.0986 86 0.09 0.0984 84 0.09 0.0979 79 0.09 0.0972 72 0.09 0.0966 66 0.09 0.0960 60 0.09 0.0957 57 0.09 0.0949 49 0.09 0.0949 49 0.09 0.0945 45 0.09 0.0943 43 0.09 0.0940 40 0.09 0.0938 38 0.09 0.0936 36 0.09 0.0935 35 0.09 0.0934 34 0.09 0.0932 32 0.09 0.0931 31 0.09 0.0929 29 0.09 0.0928 28 0.09 0.0928 28 0.09 0.0928 28 0.09266 0.09266142 142 0.09210 0.09210236 236 0.09182 0.09182677 677 0.09154 0.09154724 724 0.09123 0.09123622 622 0.090 0.09057 5748 48 0.08960 0.08960236 236 0.08904 0.08904724 724

#.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.% $#.'& # #."# #.$5 #.5# ".## $.## %.## '.#$ &.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.% $#.'& *'#.*$ # #."# #.$5 #.5# ".## $.## %.## '.#$

9429.79 9429.79 9432.79 9432.79 9436.79 9436.79 9441.79 9441.79 9446.80 9446.80 9451.80 9451.80 9466.80 9466.80 9481.83 9481.83 9511 9511.85 .85 9541.88 9541.88 9601 9601.77 .77 9662.00 9662.00 9782.12 9782.12 9902.23 9902.23

0.08849 0.08849213 213 0.08779 0.08779921 921 0.08696 0.08696457 457 0.08612 0.08612992 992 0.08529 0.08529528 528 0.08474 0.08474016 016 0.08335 0.08335039 039 0.08224 0.08224016 016 0.080 0.08071 7126 26 0.07960 0.07960236 236 0.078 0.07807 0748 48 0.07737 0.07737795 795 0.07626 0.07626772 772 0.07598 0.07598819 819

&.#$ "".#$ "5.#$ $#.#$ $5.# #.# %5.# '#.# *#.#& "$#."$ "&#.## $%#.$ '#.5 %&#.%

$6 A26n)3, i6n);2 +;n 7;2 % +i+7;2 +i+7;2 AcomulaiDn #e tiemo en minuto 20 00 00

30 00 00

40 00 00

50 00 00

60 00 00

70 00 00

80 00 00

90 00 00 10 00 00 00 0

$F @F =

($m:*r)  ($m*r) =

$ $F @F = $

($m*r)  ($r) ($m:*r)  ($m*r) = ($m*r)  ($r)

Consolidacion PLANTILLA EXCEL

Recommend Documents