Num Sum: Precise Hoop Section Volume Calculator

Volume of a Semi-Circular Hoop Section		Volume = Area of Cross Section x Length


Calculated from the Area of Hoop Section Cross Section (Using the Height = b and Width of the Hoop = Chord = C)
Get all the background info from the rest of the spreadsheets here and the design Guidelines from here.
Method =	Insert your Greenhouse Hoop dimensions to find b/C. Then get coefficient from truncated Table below and insert into F8-10
	Area = b x C x coefficient			The complete b/C Coefficient Table is here

Hoop Volume Calculator	Height of Hoop	Width of Hoop	Length of Hoop	Chord Height/Chord Width=b/C	Coefficient from Table here or from below	Hoop Section Area	Hoop Volume
Hoop Section One	7	24	96	0.2916666666666667	0.7109	119.43119999999999	11465.395199999999
Hoop Section Two
Hoop Section Three
					Total Hoop Section Volume		11465.395199999999


Coefficient Table - Get the b/C figure above, Select the appropriate Coefficient Value and Copy and Paste it above
b/C	Coefficient	Angle in Degrees	b/C	Coefficient	Angle in Degrees	b/C	Coefficient	Angle in Degrees
0.1529	0.6790	68	0.2174	0.6912	94	0.2887	0.7092	120
0.1577	0.6797	70	0.2226	0.6924	96	0.2945	0.7109	122
0.1625	0.6805	72	0.2279	0.6936	98	0.3004	0.7126	124
0.1673	0.6814	74	0.2332	0.6948	100	0.3064	0.7143	126
0.1722	0.6822	76	0.2385	0.6961	102	0.3124	0.7161	128
0.1771	0.6831	78	0.2439	0.6974	104	0.3185	0.7180	130
0.1820	0.6840	80	0.2493	0.6987	106	0.3247	0.7199	132
0.1869	0.6849	82	0.2548	0.7001	108	0.3309	0.7219	134
0.1919	0.6859	84	0.2603	0.7015	110	0.3373	0.7239	136
0.1970	0.6869	86	0.2659	0.7030	112	0.3436	0.7260	138
0.2020	0.6879	88	0.2715	0.7045	114	0.3501	0.7281	140
0.2071	0.6890	90	0.2772	0.7060	116	0.3567	0.7303	142
0.2122	0.6901	92	0.2829	0.7076	118	0.3633	0.7325	144