Cover image for Building services engineering spreadsheets
Title:
Building services engineering spreadsheets
Publication Information:
London : E & FN Spon, 1997
Physical Description:
1 computer disk ; 3 1/2 in
ISBN:
9780419226208
General Note:
Accompanies text with the same title :(TH6010 C48 1997)

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