http://www.numsum.com/spreadsheet/show/71634 Wed, 28 May 2008 08:42:39 GMT Sheep Shed Greenhouse The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Height<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Box Sections Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 2<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Main Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 0<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Section2 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 0<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Section3 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Height<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Shed and Gable Roof Sections Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 0<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Section1 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 0<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Section2 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 0<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Section3 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 18.15<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Total Square footage Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 36<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Total GH Air Volume Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 STEP ONE - Calculate the Greenhouse Volume from its Dimensions: If the calculator volume fails your design, just enter your own total here&gt;&gt; Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Don't change the italized Formula Cells or bold geen Notification Cells!!!<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Now you decide how many and how big the FANS are going to be to move all the air in the greenhouse underground 5 times per hour when the sun is shining. Play with the Number of Fans in A21 and watch the BLUE cells C21 and H25. Ideal Design Numbers should be: 5 air exchanges per hour (filled in for you) and in cell H25, 2-4 feet per sec air speed in the Underground Air Circulation Tubing. Play around with the Number of Fans and the Fan CFM in cell D21 to get close to that outcome. Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Enter the number of fans you think might work. start with one per 2000 square foot of floor space (refer to the Floor Space figured for you in cell B14) . THEN, using the calculated CFM in cell C21, choose the CFM rating for the fan you have in mind or on hand (if you have the manufacturer's data sheet, use the CFM rating for 0.1" or 0.2" backpressure) Play around with the entries until you get close to or a little more than 5 air exchanges per hour in cell E21.<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: STEP TWO Fans Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Exchange Rate TIMES/HOUR Design<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Number of Fans Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 10<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: 1 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: B24/25 and C24/25 are standard for a 4" tubing system. Enter the tubing length - anything between 30 and 70 and the enter the number of tubes you want each fan to handle. Tubing Layout Designs are discussed here and here. Then play around, watching the blue cells change... you want H25 to show about 2 to 4 feet per second (smaller numbers are better)<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: STEP THREE - Underground Air Circulation Tubing Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Tubing Diameter<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Number of Plenums (same as number of Fans) Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 4<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: 1 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Enter the values that apply in the green cells<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: STEP FOUR - Cost of system hardware Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Total Tubing Cost<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Per foot cost of your tubing in dollars (add $0.20 per foot if you need tubing with a sock soil filter) Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: $183.60<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: $0.51 Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: Enter the correct rates for your situation in the green data cells. Enter the # of days you expect to get a 1 F deg Rise in the soil temperature. In Colorado, we get at least 180 days per year of full sunny gain sufficient to raise our soil mass temperature one degree in a day. Your zone can be derated using Colorado as your reference. Florida is about the same, the NE and NW may be as low as 100, the Mid States could be around 150. I'd like to put a calculated number here based on your Degree Day and Solar Exposure data, but that will have to be managed later... for now, we are stuck with a WAG solution (wild ass guess (:-) If you know an UNVENTED greenhouse in your area can get to 90 deg F for any one day, guess how many full days that might happen - that's the figure we are after.<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: STEP Five - Payback Calculations Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: 4356<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Mass of heatsink in pounds @ soil mass at 80 lbs per cubic foot Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634 The greenhouse "BOX" sections refers to the space that is defined by the straight up walls - the volume from the floor just to the top of the walls. Then you calculate and add in the volume of the roof section above the BOX sections, usually hoops... Use the Hoop Section's calculator if you have a hoop style curved roof (see NB#2 below). NB#1: a half circle hoop house has an 180 degree included arc. NB#2: This Hoop Section calculator applies only if the Diameter of the hoop's curve is the same as the width of the greenhouse. NB#3: If NB#2 does not apply, use this sheet to get a figure to use in CELL J18. NB#4: If you have a gabled or shed roof, you can just measure the height from the top of the walls to the top of the peak - fill in the respective Length and Width that apply and you will have the volume of your shed or gabled roof section to include in the Total Greenhouse Volume.: $7.78<br/> STEP ONE - Calculate the Greenhouse Volume from its Dimensions: Gas Value gained each year Wed, 28 May 2008 08:42:39 GMT http://www.numsum.com/spreadsheet/show/71634