The comma separated values (CSV) data for spreadsheet: Copy of Copy of Precise Hoop Section Volume Calculator for Ivan

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 F10,,,,,,,,,,,, ,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,30,96,0.23333333333333334,0.6814,143.094,13737.024,,,,,, Hoop Section Two,,,,,,,,,,,,, Hoop Section Three,,,,,,,,,,,,, ,,,,,Total Hoop Section Volume,,13737.024,,,,,, ,,,,,,,,,,,,, ,,,,,,,,,,,,, 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,,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,,,,, ,,,,,,,,,,,,, ,,,,,,,,,,,,, ,,,,,,,,,,,,, ,,,,,,,,,,,,, ,,,,,,,,,,,,,

You can also export the spreadsheet's formulas instead of its calculated data.

Go back to spreadsheet: Copy of Copy of Precise Hoop Section Volume Calculator for Ivan.