
Recently I have been reviewing a few mining projects from an investor’s perspective. This led me to wonder whether junior mining companies should share more than just their drill hole highlights. What about the raw assays? A mining company announces highlighted drill intervals, but what exactly do those numbers represent?
The highlighted drill interval is based on a series of individual assay samples. The selection of the interval “From” and “To” and “Including” is made by the company using their own criteria. They may include low-grade sections (i.e. smoothing), apply variable cutoffs, sometimes use metal equivalent grades or NSR value to defines the ore/waste cutoff.
The interval definition process is largely invisible to investors, yet for early-stage projects, drill hole intervals are the primary driver of investor communications and their own project valuation.
The underlying basis for drill intervals are raw assay data. These assays can be complex, messy, technical, and may require expertise to interpret properly. However examining the individual assay data can tell more of the story than looking at intervals alone. For example, assays will demonstrate the grade continuity, any nugget effects, or whether thin high-grade spikes are boosting average grades.
This raises the question of whether companies should routinely publish, in CSV format, for download BOTH interval data and raw assay data.
This blog post discusses the pros and cons of releasing assay data electronically.
Why Might an Investor Want the CSV Data
There is a sense that many mining investors are becoming more sophisticated, and they want to fully understand the exploration process.
Some investors have geological software with which to examine the exploration data in 3D. Other investors may simply rely on Excel to run their own statistics. Investors may wish to verify what a company is doing, as well as examine their own concept for a project.
Investors might be questioning whether:
-
Companies change the nature of a deposit by smoothing narrow high grade intervals over wider intervals to give the impression of a large tonnage bulk deposit;
-
Companies are using by-product metals in their metal-equivalent, which investors have less confidence in. Perhaps they would prefer to examine the deposit based solely on their primary metals of interest. Perhaps investors prefer to understand the NSR Rock Value ($/t) instead of relying metal-equivalent grades.
-
Companies have not provided sufficient geological cross-sections or 3D images, and investors wish to create their own.
To examine any of these issues, one must have the exploration data in electronic format. For large players, signing an NDA (Non-Disclosure Agreement) and entering the corporate data room provides preferential access to this information. Small players may not be able to do this and some may consider this unfair and selective disclosure.
Highlighted Interval Data in CSV Format
Companies will disclose all highlighted drill INTERVALS in news releases, usually in table format (see example image). If someone wishes to analyze all the interval data on a project, it can be a tedious process to gather all the new releases PDF’s. The tabular data can then be scraped using Ai or one can use Excel “Get Data” functionality on a table by table basis.
This work can be cumbersome and sometimes data does not transform cleanly, often with missing rows, columns, or misaligned data.
Why make investors jump though those hoops to summarize data that’s already been disclosed? Hence, I would suggest companies maintain downloadable historical drill interval data in CSV format on their websites, in a format as presented in the news releases.
Raw assay data, however, is a different matter than interval data since assays have not been made public in the news releases. This is discussed in the next section.
Raw Assay Data in CSV Format
Deciding whether to release raw drill hole assay data is a balance between transparency and strategic risk. The only companies that are doing this (that I am aware of) is Power Metallic and (previously) Great Bear Resources. There may be more that i am not privy to.
There are both pros and cons to making the raw assay data available. Note that raw assay data files typically will also include drill hole collar coordinates and downhole survey information, the whole package.
The Pro’s and Benefits of Raw Data Disclosure
1. Market Credibility: A company being “radically transparent” can set them apart by signaling to the market confidence in their data and they have nothing to hide. This can build trust with those who want to verify the discovery. This can differentiate one from peers in a crowded junior market where transparency may be lacking.
2. Free Technical Analysis: Raw data appeals to technically sophisticated investors, geologists, and analysts who want to do their own review. The independent “super-investors” who run their own models may reach the same conclusions as the company, proving external validation for the project. They may essentially help IR with free marketing and 3rd party promotion. Of course, the opposite can also happen if the project is not as robust as being promoted by the company.
3. Speed: Raw data access may speed up due diligence for potential acquirers or JV partners who can initiate confidential internal reviews prior to deciding whether to enter a formal NDA and due diligence process.
The Con’s and Risks of Raw Data Disclosure
1. Misinterpretation & “Amateur” Experts: One risk is that someone with a very basic understanding of mining software and limited understanding of the local geology, runs flawed interpretations and publicizes their incorrect conclusions. A company may find that correcting false narratives publicly can be harder than preventing them.
Conversely stock pumpers can cherry-pick individual high-grade intervals out of context and also create misleading narratives (albeit positive) outside of the company control. They may have their own motives to pump the stock.
2. Competitive Intelligence: If in a competitive exploration district, neighbors can use raw assay values and lithology codes to predict where the mineralization is trending. This could help them acquire adjacent mineral claims before one can fully consolidate the regional land package. Regardless, competitors may still be able to do some of this using the drill hole interval data from news releases, so this may not be a big risk.
3. Liability and Compliance: NI 43-101 reporting requires technical data to be verified by a Qualified Person (QP). If one provides a raw assay file that isn’t properly vetted or contains errors, will there be regulatory or legal issues? Normally a corporate QP signs off on news releases, not necessarily an independent QP.
There have also been cases where assay data has been purposely manipulated from lab certificates to the drill hole database, and investors would then be working with this falsified data. Corporate liability could be a big risk in the eyes of some.
The Assay Disclosure Middle Ground
Once the assay data is public, it may be more difficult for a company to manage the story. A press release lets them frame results in the context of their business plan; a raw data file does not.
Instead of providing a full assay database download, some companies might follow the approach below. It may not satisfy everyone, but could be better than just ignoring requests for more detailed information.
-
Interactive Map: Use a web-based GIS tool that allows users to click holes and see downhole results graphically without downloading the full database.
-
Cross-Sections: Provide multiple high-quality cross-sections that show the geological interpretation alongside the raw assay grades or use a grade bar chart along the drill hole trace. This provides information on the grade continuity and uniformity without releasing the actual grades.
-
Post-resource estimate disclosure: Once the database has been formally audited by an independent QP and incorporated into a 43-101 technical report for a resource estimate, releasing the assay data may be lower risk.
These actions may give a sense of greater transparency while keeping the raw data within a controlled environment. It will help prevent amateurs from erroneous modeling the geology yet still “somewhat” satisfying the sophisticated mining investor.
Conclusion
For investors trying to assess a junior explorer, or geologists conducting a technical review, or a regulator trying to ensure fair and accurate disclosure, access to raw assay data can play a part in promoting good judgment and accurate disclosure from companies.
However some suggest that raw data without context is subject to misinterpretation.
Personally, I would prefer to see the release of both drill intervals and raw assay tables in CSV format.
In this modern area of Ai and investor sophistication, greater data transparency may be a positive and help build more trust in the industry. However, I understand the reasons not to do this and understand if companies choose to not go this route.
Currently the mining industry norm is that raw assays stay in private data rooms and not on corporate websites. Credibility tries to be achieved via clear, technically detailed news releases and Technical Reports.
In case you missed it, the last blog post was “What Does Ai Think of Toll Milling“.
You can sign up for the KJK mailing list to get notified when new blogs are posted. Follow me on Twitter at @KJKLtd for updates and other mining posts. The entire blog post library can be found at https://kuchling.com/library/
APPENDIX: EXCEL TASKS with and ASSAY DATABASE
I asked an Ai colleague Claude to list all the things one could do in Excel with publicly released drill hole information. Here is what it said (unedited). Its never lacking in advice and Claude will even help you create the Excel worksheet logic if needed.
Grade Analysis
-
Descriptive statistics – mean, median, mode, min/max, standard deviation of assay values (Au, Ag, Cu, etc.)
Grade frequency distributions — histogram charts to understand grade population shape.
-
High-grade outlier identification — flagging values above a threshold (e.g., >3x median) that may need capping consideration.
-
Grade capping/cutting analysis — testing different cap values and their effect on average grade.
-
Coefficient of Variation (CV) — assessing grade variability and nugget effect risk.
Composite & Interval Analysis
-
Downhole compositing — averaging assay intervals into fixed-length composites (e.g., 2m or 5m) using weighted averages.
-
True width estimation — applying trigonometric corrections for hole dip/azimuth vs. vein orientation.
Grade x thickness (GT) calculations — multiplying average grade by intercept width for comparative ranking of intersections.
-
Cut-off grade sensitivity — running intercept calculations at multiple cut-off grades to see how reported widths and grades change.
Hole Correlation & Comparison
-
Hole-by-hole grade comparison — ranking holes by peak grade, average grade, or GT value.
-
Section-by-section comparison— grouping holes by fence/section for along-strike trend analysis.
-
Depth vs. grade plots — scatter plots to look for grade zonation with depth.
-
Multi-element ratio analysis— e.g., Au:Ag ratios, Cu:Mo ratios to identify metallogenic zonation or alteration trends.
Spatial & Trend Analysis
-
Collar location plotting — basic X/Y scatter plots of collar coordinates to visualize drill pattern coverage.
-
Downhole survey data — using dip/azimuth measurements to approximate downhole trace (basic desurveying).
-
Strike and dip trend identification — plotting grade against easting or northing to identify directional trends.
-
Variogram-lite analysis — plotting grade vs. distance between holes to get a rough sense of spatial continuity (proper variography needs dedicated software).
Multi-Element & Geochemical Analysis
-
Correlation matrices — identifying which elements are positively or negatively correlated (e.g., Au vs. As in a Carlin-type system).
-
Scatter plots — visualizing element-pair relationships to identify pathfinder associations.
-
Log-transformation — applying LOG10 to skewed assay data before statistical analysis, which is standard practice.
-
Anomaly thresholding— mean + 2 standard deviations as a simple anomaly threshold for pathfinder elements.
Resource Estimation (Basic)
-
Polygonal area calculations — basic area-of-influence resource estimation using drill spacing geometry.
-
Grade tonnage curves — plotting tonnes vs. grade at varying cut-offs using simplified volume assumptions.
-
Bulk density sensitivity** — testing how different SG assumptions affect tonnage estimates.
Reporting & QA/QC
-
Duplicate analysis — comparing field duplicate, coarse reject duplicate, and pulp duplicate pairs using scatter plots and % relative difference calculations.
-
Standard performance tracking — plotting certified reference material (CRM) results against expected values and control limits (±2SD, ±3SD).
-
Blank monitoring — flagging blank samples that exceed contamination thresholds.
-
Laboratory turnaround tracking — monitoring submission dates vs. return dates.



The mining industry is implementing more and more technology in the mining cycle.
Mine reconciliation requires information such as initial predictions from exploration data and geological models, actual measurement: data from mining sources, such as blast holes, stockpile samples, or mill feed. As well it will need data on the final product being shipped off site. Do the metal quantities balance out throughout the mining operation?
Each mine site may be unique with respect to; ore sources; terminology; ore types; mining methods; stockpiling philosophy; processing methods; technology availability; and personnel capability. So often the easiest approach for mine reconciliation is based on the Excel spreadsheet. (Reconciliation is generally not an easy undertaking).

So, you just completed your initial PEA cashflow model and the resulting NPV and IRR are a little disappointing. They are not what everyone was expecting. They don’t meet the ideal targets of an IRR greater than 30% and an NPV that is more than 2x the initial capital cost. The project could now be on life support in the eyes of some.
The discounting of cashflows in a cashflow model means that up-front revenues and costs have a bigger impact on the final economics than those far off in the future. This effect is amplified at higher discount rates.
ake to the cashflow model. Sometimes several of the small ones, when compounded together, will result in a significant impact. Here are some of the other cashflow model adjustments that I have seen.
Don’t let a disappointing NPV get you down. There may be a few ways to boost the NPV by applying some common practices. However, if after applying all of these adjustments, the NPV still isn’t great, something bigger may be required. That could be an entire project scope re-think.
This article is about the benefit of preparing (cutting) more geological cross-sections and the value they bring.
Long sections are aligned along the long axis of the deposit. They can be vertically oriented, although sometimes they may be tilted to follow the dip angle of an ore zone.
Cross-sections are generally the most popular geological sections seen in presentations. These are vertical slices aligned perpendicular to the strike of the orebody. They can show the ore zone interpretation, drill holes traces, assays, rock types, and/or color-coded resource block grades.
When looking at cross-sections, it is always important to look at multiple cross-sections across the orebody. Too often in reports one may be presented with the widest and juiciest ore zone, as if that was typical for the entire orebody. It likely is not typical.
Bench plans (or level plans) are horizontal slices across the ore body at various elevations. In these sections one is looking down on the orebody from above.
3D PDF files can be created by some of the geological software packages. They can export specific data of interest; for example topography, ore zone wireframes, underground workings, and block model information. These 3D files allows anyone to rotate an image, zoom in as needed and turn layers off and on.
The different types of geological sections all provide useful information. Don’t focus only on cross-sections, and don’t focus only on one typical section. Create more sections at different orientations to help everyone understand better.
When I am undertaking a due diligence review or working on a study, very early on I like to have a look at the grade-tonnage information. This could be for the entire deposit resource, within a resource constraining shell, or in the pit design.
However, if the tonnage curve profile resembled the light blue line in this image, with a concave shape, the ore tonnage is decreasing rapidly with increasing cutoff grade. This is generally not a favorable situation.
One complaint I have about reporting mineral resources inside a resource constraining shell is the lack of strip ratio information. This applies whether disclosing a single mineral resource estimate or variable grade-tonnage data.
Regarding mineral resources, one should be required to disclose the waste tonnage and strip ratio when reporting resources inside a constraining shell. The constraining shell and cutoff grade are both based on defined economic factors such as unit mining costs, processing cost, process recoveries, and metal prices. With respect to the mining cost component, the strip ratio is a key aspect of the total mining cost, yet it normally isn’t disclosed.
In 43-101 technical reports, the financial Chapter 22 normally presents the project sensitivities expressed in a spider diagram or a table format.
NPV One is targeting to replace the typical Excel based cashflow model with an online cloud model. It reminds me of personal income tax software, where one simply inputs the income and expense information, and then the software takes over doing all the calculations and outputting the result.
Pros
Like anything, nothing is perfect and NPV may have a few issues for me.
The NPV One software is an option for those wishing to standardize or simplify their financial modelling.
We likely have all heard the statement that increasing pit wall angles will result in significant cost savings to the mining operation.
The results of applying the increased inter-ramp angle to each of the four pits is shown in the Bar Chart. Note that the waste reduction is not necessarily the same for each pit. It depends on the specific topography around each pit.
In general one can typically see four positive outcomes from adopting steeper pit walls. They are as follows:
4. Pit Crest Location: The steeper wall angles result in a shift in the final pit crest location. The Image shows the impact that the 5 degree steepening had on the crest location for one of the pits in this scenario.
It is relatively easy to justify spending additional time and money on proper geotechnical investigations and geotechnical monitoring given the potential slope steepening benefits.
Overburden is a generalized termed used to describe unconsolidated material encountered at a mine. It can consist of gravels, sands, silts, and clays and combinations of each. Usually overburden is not given much focus in many mining studies. Very often, the overburden as a unit, is not adequately characterized.
These are the clays most people are familiar with, i.e. a sedimentary deposit of very fine particles that have settled in a calm body of water. Normally consolidated clays are generally not a problem, other than having a high moisture content. As such, they can be very sticky in loader buckets, truck boxes, and when feeding crushers.
Clays in general consist of very fine plate like particles, as shown in this sketch. In over-consolidated clays, these particles have been flattened and tightly compressed as in the right image. The result is that the clay may be dense, have a good cross bedding shear strength, but very low shear strength along the plates. This characteristic is analogous to the lubricating properties of graphite, which is facilitated by sliding along graphite plates.
My experience with sensitive clays was at the former BHP bauxite mining operations along the northern coast of Suriname. There were Demerara clay channels up to 20m thick over top of many of their open pits. The bucketwheel excavators used for waste stripping would trigger the quick clay slope failures, sometimes resulting in the crawler tracks being buried and unfortunately also causing some worker fatalities.
I recall walking up towards a bucketwheel digging face as the machine quietly churned away. About 70 metres from the machine, we would see cracks quietly opening all around us as the ground mass was starting to initiate its flow towards the machine. Most times the bucketwheel could just sit there and dig. Instead of the machine having to advance toward the face, the face would advance towards the machine.
The formation of the diamond deposits in northern Canada often involved the explosive eruption of kimberlite pipes under bodies of water. The lakebed muds and expelled kimberlite by the eruption would collapse back into the crater, resulting in a mix of mud and kimberlite (yellow zones in the image). This muddy kimberlite could be soft, weak, and difficult to mine with underground methods.
At many tropical mining operations (west African gold projects for example) the upper bedrock has undergone weathering, resulting in the fresh rock being decomposed into saprolite. This clay-rich material can exceed 50 metres in thickness, can be fairly soft and diggable without blasting. This is an obvious mining cost benefit.
Compacted clay fill can also be used as a pond liner material for water retention ponds.
The DRX Drill Hole and Reporting algorithm developed by 





