• OpenGround Excel Extension Add-in Issue

    Hi all, I currently experiencing issue with the OpenGround Excel Extension where the Add-in is not showing up in Excel. Last night: it is still working fine This morning, before update: it is still working I run the update. After the update I…
  • Excel Extension - Pivot Table does not update it's data source for each worksheet in the workbook

    I am trying to make a report in the Excel Extension that summarizes data in a pivot table. When I generate the results from the template, the pivot table on the "Report" worksheet references data from the "Template" worksheet instead of the new sheet…
  • excel filter by geological field description

    Hello, I'm trying to build an excel report showing all of the shear strength parameters, grouped by geology code. For many of the tables (Pocket Pen, Triaxial, Lab PP, etc.), there is a way to reference in the Field Geological Descriptions table and…
  • Grouping/Filtering Multiple Tables in the Excel Extension?

    Hi, I'm trying to design a report template in the Excel Extension. I have multiple tables in this report that I would like to be able to group and filter by borehole. However, it seems that for multiple tables, you have to reselect the boreholes you want…
  • How do I close reports in the Excel Extension?

    I keep getting a message that I can't switch reports in the Excel Extension without closing the existing report, but there's nothing to close the report with. I have to close excel entirely and reopen the excel extension, navigate to my project and THEN…
  • Excel Extension

    Hello! I'm attempting to create an excel extension template to summarize location edit. As part of the header, I am attempting to included the coordinate system. I've tried to add it using Insert>Project Details>Coordinate System, but nothing is entered…
  • Calculating D10 from grain size data in OpenGround

    What is the best way to calculate D85, D50, D10 etc for each gradation test? Would it be to create new fields within OpenGround Professional, or tabulate as an output in the Excel Extension? What expressions would be needed to calculate?
  • OpenGround Excel Extension Multiple Charts

    Is it still possible to have multiple charts on one sheet? When I try to create more than 1 chart, the Charts info screen assigns everything to "Chart1" and does not allow it to be changed. When I GENERATE, it reassigns information from the 2nd chart…