The use of electronic spreadsheets in civil engineering

Chan, Tommy H.T. (1993) The use of electronic spreadsheets in civil engineering. In International Conference on Computer Aided Engineering & Design, 26-29 October 1993, Beijing.


Electronic spreadsheets are very common for business applications and numerous texts can be found on this topic. However, literatures on the use of spreadsheets in civil engineering is scarce. This paper attempts to demonstrate the power of electronic spreadsheets and its application in civil engineering by three examples, namely a) analysis of cantilever retaining wall; b) design of reinforced concrete beam; c) calculation of section elastic properties. The first example demonstrates how a pre-developed spreadsheet template can be treated as an interactive computer program written in other high level computer languages, e.g. FORTRAN. The second example illustrates how the power of macros in spreadsheets can make the applications developed more user-friendly. The last example shows how the graphic feature in spreadsheets greatly enhances its functionality. It is suggested that every civil engineering design office should set up a library to store the developed spreadsheet programs to increase its productivity.

Impact and interest:

Citation counts are sourced monthly from Scopus and Web of Science® citation databases.

These databases contain citations from different subsets of available publications and different time periods and thus the citation count from each is usually different. Some works are not in either database and no count is displayed. Scopus includes citations from articles published in 1996 onwards, and Web of Science® generally from 1980 onwards.

Citations counts from the Google Scholar™ indexing service can be viewed at the linked Google Scholar™ search.

Full-text downloads:

344 since deposited on 05 Mar 2008
7 in the past twelve months

Full-text downloads displays the total number of times this work’s files (e.g., a PDF) have been downloaded from QUT ePrints as well as the number of downloads in the previous 365 days. The count includes downloads for all files if a work has more than one.

ID Code: 12892
Item Type: Conference Paper
Refereed: Yes
Subjects: Australian and New Zealand Standard Research Classification > INFORMATION AND COMPUTING SCIENCES (080000) > COMPUTER SOFTWARE (080300) > Software Engineering (080309)
Australian and New Zealand Standard Research Classification > ENGINEERING (090000) > CIVIL ENGINEERING (090500)
Australian and New Zealand Standard Research Classification > ENGINEERING (090000) > CIVIL ENGINEERING (090500) > Structural Engineering (090506)
Divisions: Past > QUT Faculties & Divisions > Faculty of Built Environment and Engineering
Past > Schools > School of Urban Development
Copyright Owner: Copyright 1993 Please consult author.
Deposited On: 05 Mar 2008 00:00
Last Modified: 12 May 2011 06:12

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page