CAPPA Virtual Event: Rounding and Use of the Roundulator (Excel Add-in)
Wednesday, February 21, 2024
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 February 15.
Cicso Webex meeting invitations will be sent out on February 16 with instructions on how to join the meeting.
Speaker:
Al McCue
Al 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. Al 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 Al 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.
Al 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.
Al is married with two adult children. Now that his children are grown, he and his wife enjoy travelling.
An Interesting Fact – Al is a diver and loves diving with sharks. Every year in St Maarten, Al 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.