Guide

Exact-fraction mineral ownership

One third as a decimal is 0.333…, and three of them do not add to one. Run that through a chain of title and the error compounds into real acres and real money.

The problem

Mineral interests are fractions: an undivided 1/3, a 1/16 royalty, 3/8 of 7/8. Spreadsheets store them as floating-point decimals. Each conversion loses a little; each multiplication compounds it. Across a chain with a dozen conveyances and a handful of reservations, the total drifts away from one, and a report that should show an exact over-conveyance shows 0.99999 or 1.00001 instead.

Why "round to four places" is not a fix

Rounding hides the drift; it does not remove it. A rounded total of 1.0000 can conceal an interest that is genuinely over-conveyed by 1/1024 — a fraction that becomes acres on a large tract and dollars on a producing lease.

Exact arithmetic

Represent every interest as a rational number with arbitrary-precision integers — a numerator and a denominator that never overflow and never round. Then 1/3 + 1/3 + 1/3 is exactly 1; 1/3 of 160.33 acres is 16033/300 acres all the way to the report; and an over-conveyance is reported as exactly what it is: "over by 1/4".

Balance checking

With exact fractions, "does this tract's ownership total one?" becomes a yes-or-no question. An interest that does not total to one is flagged, not rounded away. Net mineral acres are computed from exact fractions and only then rendered as decimals for the workbook, with the fraction kept beside them.

Money too

Day rates, expenses and invoices are integer cents for the same reason: 0.1 + 0.2 is not 0.3 in floating point, and a landman's invoice should not depend on it.

In TitleDesk

Interests are stored and computed as BigInt rationals throughout the ownership screen, the acreage ledger and the reports. Mineral title research software.

On real assignments completed by working landmen, TitleDesk's automated run takes about twenty minutes for work that takes a landman three to five days; the landman then reviews and certifies. Packets, county sources and scan quality move the figure, so the ROI page shows every assumption, and we will help you qualify it on one of your own assignments. Download v0.2.5 or talk to Spencer.

See pricing Talk to Spencer