how-sure

Prediction vs. result

English · Русский

A post-drill look-back template for well predictions, in Excel.

A well recommendation is a prediction. After drilling, I go back and check it against what the bit found. A hit can be right for the wrong reason, and misses often share a cause. This workbook keeps that check in one place: one row per target, filled in before drilling and again after.

For geologists who recommend wells and the managers who sign them off.

Download the workbook (.xlsx) · One page, PDF · Одна страница по-русски, PDF

Summary sheet of the made-up example: mean depth error +8.5 m; 7 of 10 tops inside the stated range, where chance allows 6 to 10; carbonate tops +20 m deep on average, clastic tops -3 m

What it tells you

How it works

  1. Before drilling, fill the blue What we predicted columns on Look-back: the date, the top with the ± range you are ready to sign, the net reservoir, the fluid, and what the prediction rests on. Leave them as they are once the well is spudded.
  2. After drilling, fill What the bit found. The grey columns work out the depth error, the error in units of your range, the net reservoir error, whether the fluid matched, and the outcome.
  3. For every target, hits included, record whether the reasoning was right, the main cause of the difference, and what changes in the next recommendation.

Look-back sheet: prediction, result and the difference for ten made-up targets

Look-back sheet, right-hand side: outcome, whether the reasoning was right, main cause, and what changes next time

Sheets

Sheet What is on it
Start How to use it, conventions, colour key.
Look-back One row per target. Blue columns hold the prediction and the result; grey columns hold the formulas; the last columns hold the cause and the lesson.
Summary Depth bias and spread, overall and for up to four groups (type their names in the yellow cells). Tops inside the stated range against the band chance allows, with a one-line reading. Net reservoir, fluid, outcomes, hits for the wrong reason, causes.
Test 32 results from the example compared with hand-worked answers.
Lists Drop-down lists of causes, fluids and answers. Edit them for your area.

Checked against a known answer

The example is ten targets in six made-up wells, carbonate and clastic. I worked the answers out by hand and typed them into the Test sheet, which compares them with the workbook line by line. With the example in place, Test reads ALL 32 PASS.

The same 32 numbers were recomputed by separate code and by an independent spreadsheet-formula engine, and the workbook was recalculated in Google Sheets. All of them agree. Flip the sign of the depth error in one row (Look-back M8) and four lines turn to FAIL. Change or clear the example and Test reads checks off: example changed or cleared. Typing units into a number cell or leaving a range at zero gives a blank, not an error.

Limits

Conventions

Files

File What it is
prediction-vs-result.xlsx The template, with the made-up example in place.
prediction-vs-result-one-page.pdf The idea on one page, with the example chart. Also as .png.
prediction-vs-result-one-page.ru.pdf The same page in Russian. Also as .png.
screenshot-*.png The screenshots on this page.

All numbers are made up; no company data. Built with AI assistance; the geology and the checks are mine.

Licence: CC BY 4.0. Maxim Balagurov, petroleum geologist · v1.0, November 2026 · DOI 10.5281/zenodo.24242389