The big project unveiled
The university built the building in which I work around 1987. It seems our university still saw A/C as a bit of a luxury at the time and accordingly designed our building with the bare minimum to keep the offices at 78 deg. during the summer. As you might guess our professors and graduate students don't find this acceptable and with the proliferation of computers, monitors, office over crowding, etc. many of the offices actually run in the lower 80's.
Various folks have investigated this problem over the years and come to the same conclusion, insufficient air flow to the offices. Solution, complete replacement of the entire system at our department's expense.
Several months ago while reading one of my HVAC engineering magazines I came across a listing of seminars at the upcoming HVAC Expo, one of them mentioned loop duct design. This triggered a memory of another article on loop piping in a chemical plant. Eureka! Our building a perfect candidate for conversion to a loop duct system as the existing office system 80% of the way there already.
I e-mailed the author of the paper and eventually the original author in Britain. Turns out this concept indeed very promising for our building. Doing so will increase the air moving capacity of the existing ductwork by about 50%, at the same static pressure. Normally to increase air flow you have to increase the static pressure in the ductwork in order to shove the extra air through, this requires bigger fans and motors. With the loop design we essentially give the air two paths instead of one to get where it needs to go, allowing extra air flow without needing extra pressure. This opens up the possibility of increasing our total air flow without having to replace the main fans in the penthouse. A huge cost savings as the existing fans the size of a small house! This all said, cooling the offices down will take more air flow, how much more will determine whether it's reasonable to think the existing fans and cooling coils can handle the extra load. At this point I realized I needed to know how much air flow each individual office really needs to maintain 74 deg. during the summer.
Hence the beginning of the big project. Commercial cooling load design software costs thousands of dollars, but the process really not that complicated, just lots of numbers to crunch and tables to reference. Various books available that outline the process and reprint all the pertinent tables. Years ago I had constructed a spreadsheet to ease this task when our church contemplated building an addition. I started on a design for the heating and cooling systems using this spreadsheet. I simply took the parts of the tables that apply to Lansing and inputted them into various lookup tables and then set up a place to enter the room data and display the results.
Zoom ahead 10 years, now I'm trying to do this for 100 - 150 rooms vs. the 20 in our church's addition. Amazingly, the old (Version 2 I think) Lotus 123 spreadsheet loaded into the modern version of Excel (Office XP) and worked w/ very little modification! (Anyone thinking God must have played a part in this?) For the past 3 month's or so I've upgraded the spreadsheet to automatically build an output data table made up of the load values for each room at different times of day and constructed a new spreadsheet to calculate the totals by floor and for the whole building. I've also had to go through and measure all the rooms, count lights, number of people, etc and find out what kind of glass they used as the each office has wall to wall windows that take up 1/3 of the outside wall.
I'm about 3/5 of the way through the building and things are looking promising. Our building a VAV (Variable Air Volume) design, meaning the thermostats on the wall regulate the volume of cool air entering each office to control the temperature vs. older designs that used heating coils in the ductwork to simply warm the cool air back up if things got too chilly. Our building still has the heating coils for winter time, but for most of the summer they stay closed. Each pair of offices has a box above the ceiling with the control damper and heating coil. As you might guess we will need bigger boxes in order to increase the air flow. We always assumed they would cost a bundle. Actually they cost about 1/4 of what we thought and it turns out we can upgrade the capacity of many of the existing boxes by simply changing out one part.
This all very exciting to me, so much so I dove in with both feet. I'm still excited, but realize I need to proceed a bit slower, so I can keep the rest of my life in balance.
Tonight a big milestone, as I'm pretty sure I've completed all the major changes needed to the spreadsheet to get an accurate result which also looks pretty enough to present to a group. I'm tickled with all the formatting features in modern spreadsheets. I've made generous use of different font sizes, borders and colors to help separate the important from the simply included for reference. Hopefully I've done so in a way most will find tasteful rather than loud and busy.
Now I need to input the room data for the last 30 rooms I surveyed and collect the info. for the remaining 30 or so rooms. Then I'll know if the grand totals fall into a range that the existing equipment in our penthouse can accommodate.






