earthbag dome calc

	A	B	C	D	E	F	G	H	I	J	L	M	N	O
1			Earthbag Dome Calculator							Earthbag Round House Calculator
2	To edit this spreadsheet, sign into your google account and go to File - Make a copy.
3	This dome calculator is calculated according to the Earth-Cal method of dome building using a radius compass and a height compass.								This Round House Calculator assumes a cylidrical shape design. Cavities calculation is from the Dome calculator.
4	All measurements are in millimeters. You can use inches or feet etc, just make sure all inputs are the same unit of measurement.
5	Bag Width and Height are for tamped bags. 'Bag' is implied and ideally the calculation is for continous earthbag tubing.
6	Folding / closure of bags is not factored in. Use as a rough estimate only.
7
8	INPUTS			OUTPUTS					INPUTS		OUTPUTS
9	Dome Specs			TOTAL HEIGHT	AREA	TOTAL BAG LENGTH	MINUS CAVITIES		Round House Specs		AREA	TOTAL BAG LENGTH	MINUS CAVITIES
10	Radius	2000		3753.18	12566370.61	351093.51	324130.65	mm	Radius	2000	12566370.61	361283.16	334320.29	mm
11	Bag Height	120		3.75	12.57	351.09	324.13	m	Bag Height	120	12.57	361.28	334.32	m
12	Bag Width	300							Bag Width	300
13	Foundation Layers	2							Foundation Layers	2
14									Target Height	2720
15	Cavities		Length of Bag
16	Number of Doors	1	13940						CALCULATIONS
17	Door Height	2040							Outer Radius	2300
18	Door Width	820							Layers	22.67
19									Rounded Layers	23
20	Number of Square Windows	2	10666.66667						Total Layers	25
21	Window Height	800							Actual Height	2760
22	Window Width	800
23
24	Number of Circular Windows	1	2356.19449
25	Window Diameter	600
26
27	TOTAL CAVITIES		26962.86116
28
29	CALCULATIONS
30	Height Compass	4300
31	b	2300
32	angle	1.006426206
33	height	3633.180425
34	Total Foundation	28902.65241
35
36	Row	RowHeight	Compass Angle	CompassBase	Radius Inner	Radius Outer	BagLength Per Row
37
38	Foundation	-600	0	4300	2000	2300	14451.32621
39
40	1	60	0.0139539412	4299.581375	1999.581375	2299.581375	14448.69591
41	2	180	0.04187270011	4296.230906	1996.230906	2296.230906	14427.64429
42	3	300	0.06982416498	4289.522118	1989.522118	2289.522118	14385.49173
43	4	420	0.09783039625	4279.439216	1979.439216	2279.439216	14322.13899
44	5	540	0.1259138443	4265.958275	1965.958275	2265.958275	14237.43574
45	6	660	0.1540975162	4249.046952	1949.046952	2249.046952	14131.17876
46	7	780	0.1824051539	4228.664092	1928.664092	2228.664092	14003.10948
47	8	900	0.210861428	4204.759208	1904.759208	2204.759208	13852.91066
48	9	1020	0.2394921505	4177.271837	1877.271837	2177.271837	13680.20242
49	10	1140	0.2683245147	4146.130726	1846.130726	2146.130726	13484.53705
50	11	1260	0.2973873655	4111.25285	1811.25285	2111.25285	13265.39289
51	12	1380	0.3267115116	4072.542204	1772.542204	2072.542204	13022.16672
52	13	1500	0.3563300875	4029.888336	1729.888336	2029.888336	12754.16457
53	14	1620	0.3862789801	3983.164571	1683.164571	1983.164571	12460.59049
54	15	1740	0.4165973351	3932.225833	1632.225833	1932.225833	12140.53296
55	16	1860	0.4473281663	3876.905983	1576.905983	1876.905983	11792.94809
56	17	1980	0.4785190971	3817.01454	1517.01454	1817.01454	11416.63906
57	18	2100	0.5102232707	3752.332608	1452.332608	1752.332608	11010.23049
58	19	2220	0.5425004849	3682.607772	1382.607772	1682.607772	10572.13643
59	20	2340	0.575418621	3607.547643	1307.547643	1607.547643	10100.51973
60	21	2460	0.6090554709	3526.811591	1226.811591	1526.811591	9593.240157
61	22	2580	0.6435011088	3440	1140	1440	9047.786842
62	23	2700	0.6788610202	3346.640106	1046.640106	1346.640106	8461.189329
63	24	2820	0.7152603109	3246.16697	946.1669704	1246.16697	7829.897999
64	25	2940	0.7528494903	3137.897385	837.8973852	1137.897385	7149.620132
65	26	3060	0.7918126173	3020.993214	720.9932142	1020.993214	6415.089562
66	27	3180	0.8323791083	2894.408402	594.4084024	894.4084024	5619.733733
67	28	3300	0.8748414468	2756.80975	456.8097504	756.8097504	4755.175904
68	29	3420	0.919582857	2606.453529	306.4535292	606.4535292	3810.459904
69	30	3540	0.9671227868	2440.983408	0	0	0
70	31	3660	1.018196585	2257.077757	0	0	0
71	32	3780	1.073907247	2049.780476	0	0	0
72	33	3900	1.136049598	1811.077028	0	0	0
73	34	4020	1.207931334	1526.302722	0	0	0
74	35	4140	1.297145545	1162.067124	0	0	0
75	36	4260	1.434291501	585.1495535	0	0	0
76	37	4380	#NUM!	#NUM!	#NUM!	#NUM!	0
77	38	4500	#NUM!	#NUM!	#NUM!	#NUM!	0
78	39	4620	#NUM!	#NUM!	#NUM!	#NUM!	0
79	40	4740	#NUM!	#NUM!	#NUM!	#NUM!	0
80	41	4860	#NUM!	#NUM!	#NUM!	#NUM!	0
81	42	4980	#NUM!	#NUM!	#NUM!	#NUM!	0
82	43	5100	#NUM!	#NUM!	#NUM!	#NUM!	0
83	44	5220	#NUM!	#NUM!	#NUM!	#NUM!	0
84	45	5340	#NUM!	#NUM!	#NUM!	#NUM!	0
85	46	5460	#NUM!	#NUM!	#NUM!	#NUM!	0
86	47	5580	#NUM!	#NUM!	#NUM!	#NUM!	0
87	48	5700	#NUM!	#NUM!	#NUM!	#NUM!	0
88	49	5820	#NUM!	#NUM!	#NUM!	#NUM!	0
89	50	5940	#NUM!	#NUM!	#NUM!	#NUM!	0
90	51	6060	#NUM!	#NUM!	#NUM!	#NUM!	0
91	52	6180	#NUM!	#NUM!	#NUM!	#NUM!	0
92	53	6300	#NUM!	#NUM!	#NUM!	#NUM!	0
93	54	6420	#NUM!	#NUM!	#NUM!	#NUM!	0
94	55	6540	#NUM!	#NUM!	#NUM!	#NUM!	0
95	56	6660	#NUM!	#NUM!	#NUM!	#NUM!	0
96	57	6780	#NUM!	#NUM!	#NUM!	#NUM!	0
97	58	6900	#NUM!	#NUM!	#NUM!	#NUM!	0
98	59	7020	#NUM!	#NUM!	#NUM!	#NUM!	0
99	60	7140	#NUM!	#NUM!	#NUM!	#NUM!	0
100	61	7260	#NUM!	#NUM!	#NUM!	#NUM!	0