• Login
    View Item 
    •   Shocker Open Access Repository Home
    • Engineering
    • Industrial, Systems, and Manufacturing Engineering
    • IEMS: International Conference on Industry, Engineering, and Management Systems
    • IEMS 2020
    • View Item
    •   Shocker Open Access Repository Home
    • Engineering
    • Industrial, Systems, and Manufacturing Engineering
    • IEMS: International Conference on Industry, Engineering, and Management Systems
    • IEMS 2020
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    A finite difference solution for 1-D soil consolidation using Excel

    View/Open
    Conference paper (343.6Kb)
    Date
    2020-03
    Author
    McDonald, Blair J.
    Brooks, Susan C.
    Ravikumar, Prathivadi
    McDonald, Trevor W.
    Metadata
    Show full item record
    Citation
    McDonald, B.J., Brooks, S.C., Ravikumar, P., McDonald, T.W. (2020). A finite difference solution for 1-D soil consolidation using Excel. Proceedings of the 2020 IEMS Conference, 26, 40-47.
    Abstract
    Terzaghi's one-dimensional (1-D) soil consolidation equation is solved using a finite difference (FD) method and Microsoft's Excel spreadsheet. Spreadsheets are inexpensive computational tools that are readily available to students and practicing engineers. They are relatively easy to use and, in many instances, have replaced calculators. Spreadsheets can perform the complex calculations associated with design problems in any engineering discipline. They are an ideal computational tool for engineering design work, an inherently iterative process, where strings of interrelated mathematical expressions are reevaluated every time a problem parameter, such as a length, is changed. For spreadsheet calculations, all the fundamental mathematical operations are available and most also include a suite of intrinsic functions accommodating operations involving logic, statistics, calendars, finances, etc. Of all the spreadsheet features available, the ability to create and run user developed programs may be the most overlooked but powerful resource. Using Microsoft's Visual Basic Applications (VBA) development tool in Excel, a user can write/run analysis routines of their own making within a spreadsheet. This powerful feature is demonstrated using the FD method and a 1-D soil consolidation problem.
    Description
    Published in SOAR: Shocker Open Access Repository by Wichita State University Libraries Technical Services, December 2022.

    The IEMS'20 conference committee: Wichita State University, College of Engineering (Sponsor); Gamal Weheba (Conference Chair); Hesham Mahgoub (Program Chair); Dalia Mahgoub (Technical Director); Ron Barrett-Gonzalez (Publications Editor)
    URI
    https://soar.wichita.edu/handle/10057/24921
    Collections
    • IEMS 2020

    Browse

    All of Shocker Open Access RepositoryCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsBy TypeThis CollectionBy Issue DateAuthorsTitlesSubjectsBy Type

    My Account

    LoginRegister

    Statistics

    Most Popular ItemsStatistics by CountryMost Popular Authors

    DSpace software copyright © 2002-2023  DuraSpace
    DSpace Express is a service operated by 
    Atmire NV