Two different caps on data for one estimation

edited February 2022 in Leapfrog
We are currently asking ourselves what the best way is to solve an issue we're having with estimation.

As Input we have one dataset with two different drillhole types: DDH and RC (recorded in the collar file) with corresponding assay values.

In the estimation we need
  • For the longterm model a topcut A for DDH data and topcut B for RC data
  • For the shortterm model a topcut C for DDH data and topcut D for RC data
Topcuts A and C can be set in the estimator right away, but how do we go about implementing caps B and D. As the drillhole type is only recorded in the collar table and not in the assay table, we haven't been able to da a calculation on the assay table capping the data there. The option to apply queries (from the collar) to the calculations doesn't seem to be there... :( 

It feels like I'm missing something obvious here, does anyone have an idea?

Best Answer

  • AlexandervonSchéele
    Answer ✓
    Thanks everyone for your tips and inputs! We have solved the issue now, with the help of @CarrieNicholls

    Carrie's solutions:
    (1) 1. Distinguishable collar name
    • If the collar names are distinguishable then you can create a calculated ‘category calculation’ on the Assay table.
    • Advantage is that it will update when you add more data, with no or minimal adjustment to the calculation. e.g.

    (2) 2. Interval selection
    • Create query filters on the collar table for each of your drillhole types.
    • New column>Interval selection>Base column None. Name:DTYPE (or whatever)
    • Display the assay table in the Scene, view by the assay field, and apply one of the query filters.
    • Select and assign to the appropriate DH type and repeat for the others.
    • You will then have DTYPE on the assay table to apply the capping rules to.

    In the end, we decided to go with option (3), adding in the hole type as a new column in the assay table in the database export and then doing the calculations(=capping) in Leapfrog for each hole type. 

    @MikeStewart : the problem is that we have all the data in *one* dataset containing both the DDH and RC holes. So, unfortunately, we cannot do two separate calculations and then merge. But it would really be great if there was the option to use collar filters for calculations on the other tables in a data set.

    Cheers from Björkdal,



  • MichaelJMunroe
    Perhaps use calculated fields for A B C and D in the assay or composite table depending on where you want to apply the topcut. If using composites, you can apply to the composite table and then select no compositing in the estimation.
  • MikeStewart1
    Hi Alexander,
    The problem is solved in Leapfrog 2021.2.3.
    In this release, we have implemented the merging of drillhole sets.
    So, you can load DDH drilling into one drillhole set, and RC drilling in to another.
    Then create top-capped grade variables in each assay table as required.
    And finally, merge the drilling sets.
    The information you require for estimation of short and long term models, with different caps applied to DDH and RC will be available from the merged table.

    You can also composite the sets separately, and merge the composites if you wish to apply capping after compositing.

    I hope this provides the solution you need.

    The ability to reference collar filters in interval tables is also something we are considering, but not in the immediate future.

    Mike Stewart