ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
2
Note: This spreadsheet is for initial calculations only. All numbers should be confirmed by an engineer licensed in your state/country to assure safety.
3
EARTHBAG WALL ANALYSIS NEAR DOOR OPENINGS, UNDER GRAVITY CONDITIONSShear Resistance of Earthbags
4
Convert to Radians Here
5
R, Radius of Dome @ H2 above ground5.5ftCoeff. of Friction0.43Input Angle45
6
H2, Height of Doorway8.8ftAngle in Radians0.785
7
Weight Density of Earthbag130lb/ft^3Due to Earthbags @ Door Supports
8
W (Width of Doorway)3.42ftShear Strength at Top of Door403.5950579lb/ft
9
H1 (Height of Earthbag dome above Door Opening)7ftShear Strength at Bottom of Doorway933.3550579lb/ft
10
B, (Breadth of Earthbag)1ft
11
Slope of Dome in Radians (Radians, See Cell H3 to Cell I5)0.785radiansDue to Earthbags along Dome Perimeter
12
Rp, Distance of Point of application of axial load from top of doorway1.83ftShear Strength at Top of Door153.4505149lb/ft
13
T, Thickness of Wall1ftShear Strength at Bottom of Doorway683.2105149lb/ft
14
A_Tributary, Tributary area of load due to dome sloping18.97ft^2
15
Total Circumference of Earthbag Required to resist "H"
16
Dead Load due to Stucco Finishing10psfL_Req, Length of Earthbag Required9.703310586ft
17
Snow Loading57psf
18
L_Provided =34.55751919ft
19
Loads due to Opening, along Slope
20
21
Wt, Self Weight of Earthbag Dome2466.1lbHenceOK
22
Dst, DL due to Stucco189.7lb
23
DL_total=Wt+Dst2655.8lb
24
S, Snow Load1081.29lb
25
26
Unfactored Loads @ Supports of Door
27
DL (lbs)Snow (lbs)
28
H, Horizontal Load due Dome Total Dead Load & Snow Load939.3408826382.4459308
29
P, Vertical Load due to Dome Total Dead Load & Snow Load938.593158382.1415
30
31
Maximum Load Combinations for LRFD as per ASCE 7-16 Chapter 2
32
Case 1: 1.4DL
33
H1315.077236lb
34
P1314.030421lb
35
Case 2: 1.2DL + 0.5S
36
H1318.432025lb
37
P1317.38254lb
38
Case 3: 1.2DL+1.6S
39
H1739.122548lb
40
P1737.73819lb
41
42
M, Maximum Buckling Moment3180.060887lb-ft
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100