|
Mastering Royalty Calculations in Excel
Your Division Order decimal affects how you are paid. Learn how the numbers are built in this hands-on class with Melanie Finnegan, CDOA. Work through practical Excel calculations, from basic ownership interests to more complex allocation wells.
Wednesday, November 4, 2026
1:00–3:30 p.m. Central Time
The Star in Frisco
11 Cowboys Way, Frisco, TX 75034
$100 per person · Limited to 30 people
Separate class registration is required.
Recommended prerequisite: Intermediate-to-advanced knowledge of using formulas in Excel is strongly recommended to get the most from this class.
A PC is required
Bring a Windows or Mac computer with the desktop version of Microsoft Excel installed and ready to use. iPads and tablet versions of Excel are not covered in this class.
Bring your charger. Download the pre-class spreadsheet before you arrive and open it in desktop Excel on your PC. Registered participants will receive the Google Drive link in their registration confirmation and class reminders.
What you will practice
- Calculate royalty interests, tract participation factors and net mineral acres.
- Work with gross working interest (GWI) and net revenue interest (NRI).
- Explore allocation well calculations, PivotTables and Power Query workflows.
- Build confidence reviewing Division Orders and asking informed questions about ownership decimals.
Meet Melanie Finnegan, CDOA
Melanie is Manager of Land Business Systems at Comstock Resources in Frisco, Texas. She began her oil and gas career in 2006 and has worked at Comstock since 2008, including facilitating data transfers for acquisitions and divestitures.
An active DALWORTH member since 2009 and its 2018 president, Melanie has presented at DALWORTH, DFW-ALTA and NADOA events. She holds a bachelor’s degree in biophysics from Centenary College.
Who should attend
CMMs, mineral managers, family mineral administrators and royalty owners who want a practical understanding of Division Order calculations and ownership decimals.
Reserve your class seat using the registration option on this page.
|