Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
---|---|---|---|---|---|
Searching... | 30000004222729 | DSK 1639 | Open Access Computer File | Diskette (Open Shelves) | Searching... |
Searching... | 30000004222711 | DSK 1639 | Open Access Computer File | Diskette (Open Shelves) | Searching... |
Searching... | 30000004222737 | DSK 1639 | Open Access Computer File | Diskette (Open Shelves) | Searching... |
Searching... | 30000004222745 | DSK 1639 | Open Access Computer File | Diskette (Open Shelves) | Searching... |
On Order
Summary
Summary
Building Services Engineering Spreadsheets is a versatile, user friendly tool for design calculations. Spreadsheet application software is readily understandable since each formula is readable in the location where it is used. Each step in the development of these engineering solutions is fully explained.
The book provides study material in building services engineering and will be valuable both to the student and to the practising engineer. It deals with spreadsheet use, thermal transmittance, building heat loss and heat gain, combustion analysis, fan selection, air duct design, water pipe sizing, lumen lighting design, electrical cable sizing, at a suitable level for practical design work.
Commercially available software, while very powerful and comprehensive, does not allow the user any facility to look into the coded instructions. The user has to rely upon the supplier for explanation, updates and corrections. The advantage that the spreadsheet applications provided with the book have over purchased dedicated software, is that the user can inspect everything that the program undertakes. Parts of the worksheets can be copied to other cells in order to expand the size of each worksheet. Experienced spreadsheet operators can edit the cells to change the way in which data and calculations are used, and with guidance from the explanatory, build their own applications.
Table of Contents
Chapter 1 Computer and spreadsheet use |
Introdu ction |
Learning objectives |
Key terms and concepts |
Computer use |
Spreadsheet use |
As-Easy-As use |
Suitable spreadsheets |
Mathematical software |
Shareware |
Chapter 2 Thermal transmittance |
Introduction |
Learning objectives |
Key terms and concepts |
Thermal transmittance calculation |
Data requirement |
Output data |
Formulae |
Questions |
Chapter 3 Heat Gain |
Introduction |
Learning objectives |
Key terms and concepts |
Room cooling load |
Sol-air temperature |
Heat gains through the opaque structure |
Data requirement |
Output data |
Formulae |
Questions |
Chapter 4 Combustion of a fuel |
Introduction |
Learning objectives |
Key terms and concepts |
Combustion of a fuel |
Data requirement |
Output data |
Formulae |
Questions |
Chapter 5 Building Heat Loss |
Introduction |
Learning objectives |
Key terms and concepts |
Heat loss calculation |
Output data |
Formulae |
The unheated room |
Data requirement |
Output data |
Formulae |
Questions |
Chapter 6 Fan and System Selection |
Introduction |
Learning objectives |
Key terms and concepts |
Fan characteristic curves |
Anyfan |
Centfor |
Centback |
Axial |
Mixed |
Propeller |
Compare |
Data requirement |
Output data |
Formulae |
Graphical output |
Questions |
Chapter 7 Air duct network |
Introduction |
Learning objectives |
Key terms and concepts |
Air pressures in a duct |
Air flow in ducts |
Variations of pressure along a duct |
Pressure changes at a duct |
Ductwork system design |
Data requirement |
Output data |
Formulae |
Questions |
Chapter 8 Water pipe sizing |
Introduction |
Learning objectives |
Key terms and concepts |
Two-pipe circulation system |
Water flow equations |
Pipe heat emission |
Pipeline cost |
Data requirement |
Output data |
Formulae |
Questions |
Chapter 9 Lighting |
Introduction |
Learning objectives |
Key terms and concepts |
Lumen design method |
Data requirement |
Output data |
Formulae |
Questions |
Chapter 10 Electrical cable sizing |
Introduction |
Learning objectives |
Key terms and concepts |
Cable design method |
Data requirement |
Output data |
Formulae |
Questions |
References |
Index Answers |