Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki Excel Extension User Guide
    • Sign In
    • -OpenGround Wiki
      • -Applications
        • +Admin Portal
        • +Civil 3D Extension
        • +Data Collector
        • +Data Entry Module
        • -Excel Extension
          • Excel Extension Release Notes
          • +Excel Extension How Tos
          • +Excel Extension FAQ's
          • +Excel Extension Common Issues
          • -Excel Extension User Guide
            • +Creating and Modifying Reports
            • Generating Reports
        • +Launcher
        • +OpenGround Professional
        • +Portal Technical Preview
        • +Power BI Connector
        • +Template Studio
        • +Upload Portal
        • +Web API and Task Service
        • +Web Portal
      • +Guides and Learning
      • OpenGround Supported Platforms
      • +How To Contact Support
      • Component Center
      • Events
      • Training Guides
      • +Developer Resources

     
     Questions about this article, topic, or product? Click here. 

    Excel Extension User Guide

    The OpenGround Excel Extension is an add-in that sits inside Microsoft Excel and allows the user to pull data from a OpenGround project directly into a spread-sheet report.

    Excel Extension is far more powerful than Excel's simple CSV import option that you could achieve with the standard features of OpenGround  and Excel as it allows the user to design their own reports, create analysis tools, and includes many automated graphing tools.

    A few examples of reports that can be automated with the Extension for Microsoft Excel include:

    • Depth related plot
    • Laboratory result
    • Grading Envelopes
    • Statistical summaries
    • Monitoring data graphs
    • Data preparation for design calculations or external applications

    How to Use this Guide

    Primarily, this document is structured to deal with concepts and functionality in a logical and theme-based manner. As such, the guide can be read progressively. At the start of each chapter you will find an introduction section that gives you an overview of the capabilities of the system related to the chapter. You may find it useful to start by reading these introductions only as this should give you an overview of what OpenGround Excel Extension can do and which parts you need to learn more about. Further information can be found regarding a topic by the use of the related articles section of each page or elsewhere on Bentley Assist.

    Contents

     Creating and Modifying Reports
     Generating Reports
    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Tue, May 31 2022 8:38 AM
    • Marie-Claude Dubé Last revision by Bentley Colleague Marie-Claude Dubé
    • When: Thu, Jul 13 2023 2:15 PM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies