Navigation:  Fundamental Concepts > Print To Office Templates

 

Many of the views and modules in Hydro GeoAnalyst provide the option to export your data to a variety of Microsoft Office document templates.  A number of these templates are installed with Hydro GeoAnalyst and can be found under the Office Reports > Templates branch of the project tree:

 

 

There are a variety of formats and templates available as follows:

 

 

Print to Excel Template

When printing query results to to an Excel template [], you will be prompted to select an Excel Tables template. A template called 'Template-Table.xlsx" has provided with Hydro GeoAnalyst. You can find this template in the Excel Tables subfolder in the Project Tree:

 

The templates can be accessed and modified using the context menu (i.e. right-click). For example, you may want to change the logo, add titles for the project or client, etc. Templates stored in the Office/Excel Tables subfolder will be available in the drop down list under the Open Template option.

 

When printing query results to an Excel template (), you will be prompted to select a template. A template called "Template - Table.xlsx" is provided with Hydro GeoAnalyst. You can modify this template by going to the folder where your templates have been stored (see HGA Settings for more details) and adjust it to suit your needs. Perhaps you may want to change the logo, add titles for the project or client, etc. Templates stored in the Office/Excel Tables subfolder will be available in the drop down list under the Open Template option.

 

For example, Open the Chart in Excel - 2 plots by 2 parameters query in available in the HGA Demo Project using the Query Results [] module:

 

When using the Print to Excel [] option, you will be prompted to select a template:

 

Clicking OK will send the current table view to the selected Excel Template:

 

Excel Chart Templates

When printing query results to an Excel Chart template [], you will be prompted to select a chart template. Seven chart templates are provided with Hydro GeoAnalyst. You can find these templates in the Excel Charts subfolder in the Project Tree:

 

The templates can be accessed and modified using the context menu (i.e. right-click). For example, you may want to change the logo, add titles for the project or client, etc. Templates stored in the Office/Excel Tables subfolder will be available in the drop down list under the Open Template option.

 

For example, Open the Chart in Excel - 2 plots by 2 parameters query in available in the HGA Demo Project using the Query Results [] module:

 

When using the Chart in Excel [] option, you will be prompted to select a template and map the required fields for the charts.  You also have the option to group charts by a field in the Query (for example, by station).  If this is selected a worksheet and corresponding chart will be created for each unique value in the selected grouping field:

 

 

When we select OK, we get the Mappings dialog:

 

 

The chemical names automatically match because they are exactly the same within our template as they are stored within the database. Also make sure that you map the Date field. Then select OK and you will be prompted for a name for the excel spreadsheet that will be created. Once you provide a name it will open in Excel and you can review to see that each station has its own tab for the time series chart.

 

 

 

Excel Pivot Templates

When printing query results to an Excel Pviot template [], you will be prompted to select a pivot template. Two chart templates are provided with Hydro GeoAnalyst. You can find these templates in the Excel Charts subfolder in the Project Tree:

 

The templates can be accessed and modified using the context menu (i.e. right-click). For example, you may want to change the logo, add titles for the project or client, etc. Templates stored in the Office/Excel Tables subfolder will be available in the drop down list under the Open Template option.

 

For example, Open the Chart in Excel - 2 plots by 2 parameters query in available in the HGA Demo Project using the Query Results [] module:

 

When using the Create Excel Pivot [] option, you will be prompted to select a template:

 

When we select OK and select a filename, the pivot file will open in Excel.

 

 

The Excel spreadsheet will open and you can select inside the Pivot Table option. This will make all the fields from the query available in the Pivot Table Field List so that you can pivot your data:

 

 

 

PowerPoint Templates

Results from several modules can be printed to a PowerPoint Template using the Print to PowerPoint button [], including:

• Query Results

• Well Profile

• Map Viewer

• Scene Viewer

• Plot Collections

 

When printing results to a Power Point template [], you will be prompted to select a module-specific PowerPoint template. Templates are available for each of these modules in Hydro GeoAnalyst. You can find these templates in the PPT subfolders in the Project Tree:

 

The templates can be accessed and modified using the context menu (i.e. right-click). For example, you may want to change the logo, add titles for the project or client, etc. Templates stored in the Office/Excel Tables subfolder will be available in the drop down list under the Open Template option.

 

Query Results

For example, open the Chart in Excel - 2 plots by 2 parameters query in available in the HGA Demo Project using the Query Results [] module:

 

When using the Print to PowerPoint [] option, you will be prompted to select create a new template:

You will be prompted to Create a new template. Enter a name for the query PowerPoint template:

 

Click OK and a new PowerPoint file will open:

 

Note the entries in surrounded by '#' symbols - these are the fields in the template.  Save and close the template. Hydro GeoAnalyst will confirm that the new template has been created and saved to the Project tree:

 

Click OK and select a name for the specific query report you have executed, for example: "Ion Report" as shown below:

 

Click OK and the printed report will be displayed in PowerPoint, with one page per record:

 

As you can see, the result is not ideal - the fields are too close and span multiple lines such that they overlap.  You can fix this by right clicking on the template you created in the project tree and selecting open:

 

The template will open in PowerPoint and you can make adjustments. For example,  spreading out and vertically distributing the query field placeholders, adding labels to the left of the query field placeholders, and adding a title for the Report:        

 

Save and Close the PowerPoint template and select the Print to PowerPoint template [] option once again repeating the steps above.  This time, the template will include your improvements:

 

Well Profiles

Simple Well Profile Templates

For example, in the HGA Demo Project, select the "Boreholes with plot data" station group from the Project tree and open the "bhlp_intervals" in the Well Profile module []:

 

When using the Print to PowerPoint template [] option, you will be prompted to select a template. You will also have the option to choose to export the current station or all stations in the current station group as well as how to handle the depth of each each well (i.e. fixed depth intervals across multiple pages or one page per well at a specific depth):

 

Click Browse and enter a name for the report (such as "BHLP Intervals"):

 

When we select OK twice, the PowerPoint report file will open:

 

The resulting report shown above includes an image from the well profile, but could it could be supplemented using information from a query that includes metadata about the station. For this, we can use a query based well profile template as described below:

 

Query Based Well Profile Template

Before creating a Query-based Well Profile Template, we must first create a query for the template to use.  The query should return one record for each station and should ideally not include any conditions so that it can be used in combination with any station group that might be used with the Well Profile Template.

•Open the Query Builder module [] from the Modules menu or the main toolbar

•Select New Query [] and provide a name for the query (e.g. "BHLP Interval Well Profile template query"):

•Add the display fields that you'd like include as data values in the template to the query, for example:

•Save [] the query and return to the Well Profile tab

•Open the Print to PowerPoint template [] dialog again and select the New option:

 

•Define the basic structure of the new template:

oSelect a base template (e.g. NewTemplateBase.pptx)

oProvide a name (e.g. BHLP Interval Well Profile template query)

oCheck the checkbox for "Create template based on query"

oSelect a source query (e.g. "BHLP Interval Well Profile template query")

•Click OK and PowerPoint will load the Template with tags for each field (e.g. #Station Name# for the Station Name field) and an "Image Placeholder" image that will be used to place the well profile images:

 

Note that you can also add the tags #PAGE# and #PAGECOUNT#. The tag #PAGE# will be replaced by the page number and the total number of pages for a given station. For example, if you export the wells in 50 m increments, then GB-03 will be split into a total of two pages with the interval for 50m-100m below ground surface would be shown as page 2 of 2.

Also, the well profile images will be stretched to fill the "Image Placeholder" while maintaining the aspect ratio shown on the screen. If you are aiming to have the well profile images scaled to a particular dimension on the page, then be sure to make the "Image Placeholder" the exact height desired on the page and sufficiently wide to accommodate the desired height.

 

•Format the new template as desired. For example:

•Save the template and close PowerPoint

•Setup the Export:

oSet a Report Path (e.g. BHLP intervals)

oselect the desired Station group (e.g. Boreholes with Plot data)

oset the depth settings (e.g. multi-page with 50m per page)

•Click OK to export and the printed PowerPoint report will open:

 

Cross Sections

For example, in the HGA Demo Project, double click on the "AA" cross section from the Project tree to open it:

 

To export the cross section to a template:

Click the Export [] option to open the Export cross section window, and you will have options to select which cross section(s) should be exported, the file format (images or PowerPoint presentation), and related settings:

 

To export to a PowerPoint template, select Presentation under the Export Type section and select a template, for example: "Template - Letter_Landscape.pptx".

Click the option next to "Selected cross sections" to export all cross sections into a single presentation with one slide/page per cross section.

Click Browse and enter a name for the report (such as "Cross Sections"):

 

Click OK and Export to export the cross section(s)

When we select OK twice, the PowerPoint report file will open:

 

The resulting report shown above includes each cross section on a separate slide.

 

Map Views

For example, open a Map Viewer object from the project tree such as the "Map" you may have created while completing the Mapping portion of the Demo Project Tutorial:

 

Click the Export to Image or presentation [] option and you will be prompted to select the export type (image or presentation), and an export location. When you select presentation, you will also be prompted to select a presentation template:

 

Click the Browse button to select a location for the exported presentation to be stored. Enter a name such as "Printed Map". If you select the Save to project tree option, the file will be saved in the project folder and be accessible from the project tree:

 

Click OK twice to close both windows and begin exporting the map. Once the export process has completed, the exported map will open in PowerPoint:

 

 

 

Scene Views

For example, in the HGA Demo Project, double click the "BTEX_ColorMaps" Scene from the Project tree to open it:

 

When using the Print to PowerPoint template [] option, you will be prompted to select a template and an output filename (click Browse):

When you select OK, the PowerPoint report file will open:

 

Plot Collections

For example, in the HGA Demo Project, select the "Water Quality Plots" plot collection from the project Tree:

 

For this example, we will use a pre-defined template that is installed with Hydro GeoAnalyst.  The template includes an image placeholder that defines the size and location in the template where the plots will be placed. In this case, the image placeholder is 7.55 inches wide by 9.55 inches tall (19.18 cm x 24.26 cm).

To access the Print to PowerPoint template functionality, turn on the Export pane using the "Export to images or presentation"-[] button option.  

•Select the "Presentation" as the Export option

•Set the layout settings:

oLayout: Custom

oWidth: 7.55 in (19.18 cm)

oHeight: 9.55 in (24.26 cm)

oMargins: 0

oOrientation: Portrait

oDPI: medium

oExport with margins: unchecked

 

•Click the Browse button next to the Report path entry and enter a name for the report (such as "Water Quality"):

 

•Select the Template: Template - Letter_Portrait.pptx.

 

•Select Whole Plot Collection to export all plots. In this case, one page will be generated with both of the two plots in this plot collection.

When we select Export, the PowerPoint file will open:

 

 

---

Page url:https://www.waterloohydrogeologic.com/help/hga/index.html?print-to-office-templates.htm