Using the Enhanced PCBC/PCSLC Excel™ Transfer Tool

By

It’s Tip Tuesday! Today we are diving into our GEOVIA PCBC/PCSLC™ solution with a guest post from Tony Diering, Vice President of GEOVIA’s Caving Business Unit.

The Transfer Bucket Data between Workspace and Excel™ is one of the most widely used menu items in PCBC. Therefore, it should be of no surprise that a new enhancement, which increases this tool’s efficiency, was incorporated into the recent release of GEOVIA GEMS™ 6.5.

You often require a bucket (draw point data) in which groups of draw points have the same value. With the previous version of PCBC, each draw point had to be set up in Excel. Consider if you had 3000 draw points, the Excel file would need 3001 rows set up. But now, if the draw points are grouped into tunnels o sectors, then only one line of data is required for each of these sectors of tunnels.

The first step is to set up the Excel file and sheet for input. In the next step, set up the mappings, which link fields in the workspace to associated columns in Excel. All draw points with the field called PBLOCK will be matched up with the data in the Excel column called PBLOCK. This will be used to create two new buckets of data, called PB1 and Max.

TIP: Adjust the Last Row input from the number of draw points to the number of tunnels +1 – this is particularly useful for setting up data grouped by tunnels such as PRC and tonnage values

Within the GEMS PCSLC module, there’s a very natural application for setting up data grouped by level such as extraction percentages or level names, etc. This is a convenient input format. Columns are used to set up buckets for the offset display tool for ring display. The EXTR% would be used to create a bucket of extraction percentages for each ring of each level in a project.

For more infromation on this tip, check out page 17 from the latest issue of Inside GEOVIA.

Be sure to check back next Tuesday for more Product Tips & Tricks.

0
GEOVIA

GEOVIA

When mining companies seek to increase mine productivity, they turn to Dassault Systèmes for technology and services. It is home to world-renowned and award-winning mining solutions and to industry thought leaders who are pushing the boundaries of what’s possible in mining, through the GEOVIA brand. The largest global supplier of mining software, GEOVIA delivers comprehensive solutions in all major mining centers in more than 130 countries at over 4,000 sites.
GEOVIA

Latest posts by GEOVIA (see all)