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 | |