Copy of copy

profileFoot
CopyofCopyofENGR431_Fall2020_Project-part3spreadsheet.xlsx
Home>Engineering homework help>Copy of copy

Sheet1

Case POI in layer σi' σp' σf' εv ᇫH
1-1 2 center 1428.1 5428.1 3432.2 0.1409 1.4090 1-1 ᇫH
H=10 edge 1428.1 5428.1 2430.2 0.0854 0.8543 Center 1.9865
corner 1428.1 5428.1 1929.2 0.0483 0.4833 Edge 1.2533
H=7 4 center 2310.1 6310.1 4173.82 0.0272 0.1906 Corner 0.7400
edge 2310.1 6310.1 3312.1 0.0166 0.1161
corner 2310.1 6310.1 2811.1 0.0090 0.0633
H=56 6 center 4790.4 8790.4 5752.32 0.0066 0.3694
edge 4790.4 8790.4 5471.76 0.0048 0.2684
corner 4790.4 8790.4 5241.3 0.0032 0.1816
H=58 8 center 8656.8 12656.8 8997.48 0.0003 0.0175
edge 8656.8 12656.8 8937.36 0.0002 0.0145
corner 8656.8 12656.8 8887.26 0.0002 0.0119
1-2 4 center 2415.3 6415.3 6606.5 0.0504 0.1512 1-2 ᇫH
H=3 edge 2415.3 6415.3 4643.9 0.0301 0.0903 Center 1.2163
corner 2415.3 6415.3 6757.3 0.0546 0.1637 Edge 0.7760
H=56 6 center 4790.4 8790.4 7911 0.0181 1.0126 Corner 0.6243
edge 4790.4 8790.4 6573.7 0.0114 0.6388
corner 4790.4 8790.4 5815.8 0.0070 0.3915
H=80 8 center 9158.4 13158.4 9961 0.0007 0.0525
edge 9158.4 13158.4 9872 0.0006 0.0469
corner 9158.4 13158.4 10228 0.0009 0.0691
1-3 6 center 4790.4 8790.4 8259.15 0.0196 1.0995 1-3 ᇫH
H=56 edge 4790.4 8790.4 6712.28 0.0122 0.6809 Center 1.1586
corner 4790.4 8790.4 5938.84 0.0077 0.4338 Edge 0.7327
H=80 8 center 9226.8 13226.8 10140.9 0.0007 0.0591 Corner 0.4723
edge 9226.8 13226.8 10023.7 0.0006 0.0518
corner 9226.8 13226.8 9812.74 0.0005 0.0385
1-4 8 center 9796.8 13796.8 11882.7 0.0015 0.1630
H=108 edge 9796.8 13796.8 11203.1 0.0010 0.1132
corner 9796.8 13796.8 10694.1 0.0007 0.0740
1-5 6 center 4790.4 8790.4 7297.23 0.0152 0.8496 1-5 ᇫH
H=56 edge 4790.4 8790.4 6030.92 0.0083 0.4649 Center 0.9000
corner 4790.4 8790.4 5487.94 0.0049 0.2744 Edge 0.4945
H=83 8 center 9226.8 13226.8 9972.53 0.0006 0.0504 Corner 0.2939
edge 9226.8 13226.8 9873.68 0.0005 0.0297
corner 9226.8 13226.8 9647.41 0.0003 0.0195
1-6 6 center 4790 8790 6623 0.0117 0.6541 1-6 ᇫH
H=56 edge 4790 8790 5671 0.0061 0.3408 Center 0.6815
corner 4790 8790 5214 0.0031 0.1712 Edge 0.3639
H=83 8 center 9226 13226 9624 0.0003 0.0274 Corner 0.1844
edge 9226 13226 9560 0.0003 0.0231
corner 9226 13226 9415 0.0002 0.0132
1-7 8 center 9796.8 13796.8 11200.3 0.0010 0.1130
H=108 edge 9796.8 13796.8 10011.1 0.0002 0.0183
corner 9796.8 13796.8 10255.2 0.0004 0.0386
2-1 4 center 2310.1 6310.1 14122.6 0.1950 1.3647 2-1 ᇫH
H=7 edge 2310.1 6310.1 8216.35 0.0950 0.6649 Center 1.7241
corner 2310.1 6310.1 5263.23 0.0379 0.2654 Edge 0.8661
H=16 6 center 3678.4 7678.4 6859.63 0.0225 0.3594 Corner 0.3685
edge 3678.4 7678.4 5214.03 0.0126 0.2012
corner 3678.4 7678.4 4398.71 0.0064 0.1031
2-2 4 center 2494.2 6494.2 4775.19 0.0299 0.4186
H=14 edge 2494.2 6494.2 3634.7 0.0173 0.2427
corner 2494.2 6494.2 3064.45 0.0095 0.1327
2-3 6 center 4032.4 8032.4 8907.9 0.0379 1.1754
H=31 edge 4032.4 8032.4 6470.4 0.0170 0.5284
corner 4032.4 8032.4 5251.65 0.0095 0.2952
2-4 6 center 3487.5 7487.5 5470.97 0.0162 0.2110
H=13 edge 3487.5 7487.5 4479.24 0.0090 0.1173
corner 3487.5 7487.5 3983.37 0.0048 0.0623
2-5 8 center 7987.2 11987.2 12360.3 0.0074 0.2081
H=28 edge 7987.2 11987.2 10166.6 0.0019 0.0528
corner 7987.2 11987.2 9069.08 0.0010 0.0278
2-6 8 center 7563.4 11563.4 9348.52 0.0017 0.0166
H=10 edge 7563.4 11563.4 8455.96 0.0009 0.0087
corner 7563.4 11563.4 8009.678 0.0004 0.0045
2-7 4 center 2310.1 6310.1 12278.92 0.1691 1.1840 2-7 ᇫH
H=7 edge 2310.1 6310.1 7234.39 0.0715 0.5004 Center 1.4315
corner 2310.1 6310.1 4772.245 0.0334 0.2338 Edge 0.6219
H=16 6 center 3578.4 7578.4 5496.93 0.0155 0.2476 Corner 0.2890
edge 3578.4 7578.4 4417.425 0.0076 0.1215
corner 3578.4 7578.4 3937.793 0.0034 0.0552
2-8 4 center 2320.1 6320.1 3858 0.0234 0.1639
H=7 edge 2320.1 6320.1 3014 0.0120 0.0843
corner 2320.1 6320.1 2662 0.0063 0.0443
2-9 6 center 5939.4 9939.4 9424.5 0.0166 0.5159
H=31 edge 5939.4 9939.4 7561.71 0.0087 0.2698
corner 5939.4 9939.4 6660.375 0.0041 0.1280
2-10 6 center 3487.5 7487.5 3968.93 0.0047 0.0606
H=13 edge 3487.5 7487.5 3628.11 0.0014 0.0185
corner 3487.5 7487.5 3497.59 0.0001 0.0014
2-11 8 center 7972.8 11972.8 11475.5 0.0028 0.0797
H=28 edge 7972.8 11972.8 9815.85 0.0016 0.0455
corner 7972.8 11972.8 8804.15 0.0008 0.0217
2-12 8 center 7563.4 11563.4 8897.62 0.0013 0.0127
H=10 edge 7563.4 11563.4 8075.2 0.0005 0.0051
corner 7563.4 11563.4 7724.11 0.0002 0.0016
Case Center to Edge Center to Corner Edge to Corner
1-1 ρ L ρ/L ρ L ρ/L ρ L ρ/L
mat 0.73324 40 0.01833 1.25 56.57 0.02 0.5132 40 0.01283
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
1-2 ρ L ρ/L ρ L ρ/L ρ L ρ/L
mat 0.44030 40 0.01101 0.59 56.57 0.01047 -0.1517 40 -0.00379
Pass or Fail Pass Pass Pass
Case Center to Edge Center to Corner Edge to Corner
1-3 ρ L ρ/L ρ L ρ/L ρ L ρ/L
end bearing piles 0.42589 40 0.01065 0.69 56.57 0.01 0.2604 40 0.00651
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
1-4 ρ L ρ/L ρ L ρ/L ρ L ρ/L
end bearing piles 0.04972 40 0.00124 0.09 56.57 0.0016 0.0393 40 0.00098
Pass or Fail Pass Pass Pass
Case Center to Edge Center to Corner Edge to Corner
1-5 ρ L ρ/L ρ L ρ/L ρ L ρ/L
end bearing piles 0.40550 40 0.01014 0.61 56.57 0.0107 0.2006 40 0.005015
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
1-6 ρ L ρ/L ρ L ρ/L ρ L ρ/L
end bearing piles 0.31758 40 0.00794 0.50 56.57 0.01 0.1795 40 0.00448789
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
1-7 ρ L ρ/L ρ L ρ/L ρ L ρ/L
end bearing piles 0.09477 40 0.00237 0.07 56.57 0.001 0.0203 40 0.00050847
Pass or Fail Pass Pass Pass
Case Center to Edge Center to Corner Edge to Corner
2-1 ρ L ρ/L ρ L ρ/L ρ L ρ/L
9 columns 0.85803 40 0.02145 1.36 56.57 0.02 0.4976 40 0.0124398
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
2-2 ρ L ρ/L ρ L ρ/L ρ L ρ/L
36 columns 0.17589 16 0.01099 0.29 22.63 0.0126 0.1100 16 0.00687426
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
2-3 ρ L ρ/L ρ L ρ/L ρ L ρ/L
9 columns 0.64695 40 0.01617 0.88 56.57 0.02 0.2332 40 0.0058301
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
2-4 ρ L ρ/L ρ L ρ/L ρ L ρ/L
36 columns 0.09372 16 0.00586 0.15 22.63 0.01 0.0550 16 0.00343619
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
2-5 ρ L ρ/L ρ L ρ/L ρ L ρ/L
9 columns 0.15533 40 0.00388 0.18033 56.57 0.00319 0.02500 40 0.00063
Pass or Fail Fail Fail Pass
Case Center to Edge Center to Corner Edge to Corner
2-6 ρ L ρ/L ρ L ρ/L ρ L ρ/L
36 columns 0.00784 16 0.00049 0.01 22.63 0.00053 0.0042 16 0.000265
Pass or Fail Pass Pass Pass
Case Center to Edge Center to Corner Edge to Corner
2-7 ρ L ρ/L ρ L ρ/L ρ L ρ/L
9 columns 0.80963 40 0.02024 1.14254 56.57 0.02 0.3329 40 0.008323
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
2-8 ρ L ρ/L ρ L ρ/L ρ L ρ/L
36 columns 0.07956 16 0.00497 0.12 22.63 0.00528 0.0400 16 0.0025012
Pass or Fail Fail Fail Pass
Case Center to Edge Center to Corner Edge to Corner
2-9 ρ L ρ/L ρ L ρ/L ρ L ρ/L
9 columns 0.24608 40 0.006152 0.38790 56.57 0.006857 0.14 40 0.0035457
Pass or Fail Fail Fail Fail
Case Center to Edge Center to Corner Edge to Corner
2-10 ρ L ρ/L ρ L ρ/L ρ L ρ/L
36 columns 0.04207 16 0.00263 0.06 22.63 0.00262 0.0172 16 0.001073
Pass or Fail Pass Pass Pass
Case Center to Edge Center to Corner Edge to Corner
2-11 ρ L ρ/L ρ L ρ/L ρ L ρ/L
9 columns 0.03419 40 0.00085 0.06 56.57 0.001025 0.02 40 0.0006
Pass or Fail Pass Pass Pass
Case Center to Edge Center to Corner Edge to Corner
2-12 ρ L ρ/L ρ L ρ/L ρ L ρ/L
36 columns 0.00758 16 0.00047 0.01 22.63 0.00049 0.0035 16 0.000217
Pass or Fail Pass Pass Pass