Monday, October 20, 2025

11:45 am – 1:00pm

Venue: Virtual via Webex

As production accountants, we are asked to endlessly allocate series of numbers. For example, sales volumes are allocated from a single measurement point back to multiple dimensions: producing entities, partners, products, components, purchasers, contracts, etc. It’s extremely important that when series are allocated to a new dimension all allocated results sum correctly to the control totals from the prior dimension.

This lunch & learn will explore

• Rounding theory
• Use of the progressive rounding algorithm
• Rounding within Excel spreadsheets
• Why the Excel @round function fails
• Use of an Excel add-in file called the Roundulator_CNTL_Q that provides on-demand fixed point progressive rounding within Excel

Seminar Materials

Attendees will be sent the following files closer to the event date.

• Powerpoint Slide deck – Rounding
• Excel File 1 – Roundulator_CNTL_Q
• Excel File 2 – Example file for to demonstrate the use of the roundulator

Registration Closes Noon October 16.

Cicso Webex meeting invitations will be sent out on October 17th with instructions on how to join the meeting. 

Speaker:

Allan McCue

Allan McCue was born in Edmonton AB and raised in Calgary. He holds a BSc in Chemical Engineering from the UofC and a CAPPA certificate from SAIT. Allan has spent most of his career working with computerized production accounting and field data capture systems in the development, support, implementation, marketing and training departments. He was one of the co-architects of the gas allocations engine in PAS.

Early in his career Allan spent several years in the field working on well cementing, acidizing and fracturing crews, on pipeline crews, and as a field operator for Texaco in the Drayton Valley area.

Allan is a senior instructor in the CAPPA program and has taught the well operations and field reporting section if the CAPPA program at SAIT and Mount Royal since 1984.

He is currently president of his own consulting company, Apogee Services.

His current work involves implementing field data capture systems, assisting companies with their EPAP audits, solving gas allocation issues and working with companies on PAS implementations.

Allan is married with two adult children. Now that his children are grown, he and his wife enjoy traveling.

An Interesting Fact – Allan is a diver and loves diving with sharks. Every year in St Maarten, Allan goes on a shark dive with up to a dozen Caribbean reef sharks up to 8 feet long that swim mere inches away from the divers.

Price:

Members Free

Non-members $20 plus GST

Cancellation policy:

– Full refunds will be given up to 10 days prior to the event.
– A 50% refund will be given up to 6 days prior to the event.
– Refunds will not be provided thereafter. 

There is an administration fee of $20 to cancel.

Registration, however, may be transferred to another attendee without an administration fee. Please notify CAPPA of the transfer to another attendee. The original registrant would be responsible to sort the payment out offline with the new attendee.