| SHCS Calculator SHCS Calculator | | | |
| Basic Instructions: First and foremost, be sure to CLEAR any bold faced entries in the cells that don't apply to you (don't delete the cell contents! - select the cell to clear, then go to the "cells" menu and select "clear cells".) THEN follow these STEPS - STEP ONE - Calculate the Greenhouse Volume - fill in ALL the yellow cells that apply. STEP TWO - Select the number and size of the FANS to use - Play around with the GREEN DATA CELLS to get close to the desired outcome in the BLUE CELLS E21 and H25. STEP THREE - Calculate your Underground Air Circulation Tubing quantities. STEP FOUR - Calculate your Hardware costs. STEP FIVE - Calculate your Payback figures by filling in the unit energy costs from your utility bills. If you have any anomolies with the sheet, check out Numsum's help and support, they are VERY open , helpful and FAST to respond. Whoopeee! Let's get started. And don't forget, if you register as a Numsum user, you can save a copy of the SHCS Calculator for your personal use and display to others. I would be happy to look at your numbers and make suggestions based on your figures. Join up and create a copy for others to see! | | |
| First, we calculate the volume of air in the greenhouse - fill in the yellow DATA cells in the Greenhouse Dimensions yellow section below | | |
| | | | | | |
| NOTE: Your important Calculated figures are in cells this color for the entire sheet | | | |
| | | | | | | | | |
| DIRECT YOUR QUESTIONS SPECIFIC TO THIS SHEET'S TERMS AND METHODS TO THE SHCS FORUM. Ask any questions you have and get answers from me directly and from the rest of the community of solar greenhouse builders interested in the possibilities and opportunities listen in and respond. | | |
| | | | | | | | | |
| STEP ONE - Calculate the Greenhouse Volume from its Dimensions STEP ONE - Calculate the Greenhouse Volume from its Dimensions | 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. |
| Box Sections Box Sections | Height | Length | Width | Section Sub total CUFT Section Sub total CUFT | Hoop Sections | Arc Included | Radius | Length | Hoop Section Sub Total CUFT |
| Main | 2 | 6 | 3 | 36 | Main | | | | |
| Section2 | 0 | .5 | .3 | | Section2 | | | | |
| Section3 | 0 | 0 | 0 | 0 | Section3 | | | | |
| Shed and Gable Roof Sections | Height | Length | Width | | | | | | |
| Section1 | 0 | 21.5 | 10.83 | | | | | | |
| Section2 | 0 | 10.13 | 10.13 | | | | | | |
| Section3 | 0 | 0 | 0 | | | | | | |
| Total Square footage | 18.15 | Design should be 1.33 feet of tubing per square foot | 24.139499999999998 | | You can get more precise figures for your Hoop Section Volumes from here. Remember to zero out or clear the contents of calculator cells above if you use that other calculator - place the figure you get in the next cell over (just above the calculated value for "Total Hoop Volume CU/ft" - it should be blank before you add the figure from the other calculator) | |
| Total GH Air Volume | 36 | | Total Section CUFT | 36 | | | | Total Hoop Section CU/FT | |
| If the calculator volume fails your design, just enter your own total here>> | | | | | | | | | |
| | | | | | | | | |
| 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. | Don't change the italized Formula Cells or bold geen Notification Cells!!! | | |
| | | | | | | | | |
| STEP TWO Fans | 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. | | |
| Number of Fans | Exchange Rate TIMES/HOUR Design | Fan CFM Calculated | Fan CFM from Manufacturer List | Exchange Rate TIMES/HOUR Calculated | | | | | |
| 1 | 10 | 6 6.00 | 212 | 353.33333333333337 353.33 | | | | | |
| | | | | | | | | |
| STEP THREE - Underground Air Circulation Tubing STEP THREE - Underground Air Circulation Tubing | 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) | |
| Number of Plenums (same as number of Fans) | Tubing Diameter | Effective Diameter | Average Length of tubing | # of tubes in each plenum | Total Tubing Effective Area SQFT | Total Feet of Tubing | Tubing Air Speed FT/SEC | Time in each Tube in SEC | |
| 1 | 4 | 3.75 | 20 | 18 | 1.3798828125 1.37 | 360 360.00 | 2.5606039160179286 2.56 | 7.810657429245284 | |
| | | | | | | | | |
| STEP FOUR - Cost of system hardware | Enter the values that apply in the green cells | | |
| Per foot cost of your tubing in dollars (add $0.20 per foot if you need tubing with a sock soil filter) | Total Tubing Cost | Cost of each Fan Plenum package (change to reflect your fan costs - plenums are $10-$15) | Total Fan and Plenum cost | Controls Package (only one required per greenhouse system) | Total Hardware Costs | | | | |
| 0.51 $0.51 | 183.6 $183.60 | 187 $187.00 | 187 $187.00 | 100 $100.00 | 470.6 $470.60 | | | | |
| | | | | | | | | |
| STEP Five - Payback Calculations | 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. | |
| Mass of heatsink in pounds @ soil mass at 80 lbs per cubic foot | 4356 | Heat stored with a 1 F deg rise in soil temp | 4356 | Your Therm cost ($ per 100,000 BTU's) go here for rates | 2.55 $2.55 | Stored heat value as natural gas cost per 1 F deg rise | 0.111078 $0.11 | # of days you expect get a 1 F deg Rise in the soil temperature. | 70 |
| Gas Value gained each year | 7.77546 $7.78 | Your Electricity Cost in $/kilowatt hour (rates here) | 0.2 $0.20 | Operating cost - fans @ 2 amps for 8 hrs/day | 13.440000000000001 $13.44 | Yearly Net | -5.6645400000000015 -$5.66 | Hardware Payback in Years | -83.07823759740418 |
| | |
| | | | | | | | | |
| | | | | | | | | |
