Ive found power query to be more useful than macros in some situations and it's helped me with setting up preliminary costing distributions.
Original Message:
Sent: 01-28-2025 11:18 AM
From: Eric Christoph
Subject: Project Controls Reimagined: Unlocking the Power of AI
Not so sure about Python in Excel, but PowerQuery is a game changer for sure. And simple stuff in Power Query is, well, simple! Worth a YouTube video or two to get familiar.
------------------------------
Eric Christoph
Partner
Leesburg
eric@transformativems.com
------------------------------
Original Message:
Sent: 01-25-2025 09:05 AM
From: John Hollmann
Subject: Project Controls Reimagined: Unlocking the Power of AI
Lance, I will confess that at this point in my career my momentum is fading in trying to keep on top of it all the nitty-gritty, including what you now suggesting are basics (e.g., Python in Excel). But I hope I will have something to offer to the conversation until I am old enough to be President ;)
------------------------------
John Hollmann
Owner
Validation Estimating LLC
Ashburn
jhollmann@validest.com
Original Message:
Sent: 01-24-2025 03:57 PM
From: Lance Stephenson
Subject: Project Controls Reimagined: Unlocking the Power of AI
Thanks, John. We still have some work to do! Analytics (algebra and stats) have always been there; we just were not using them. To be honest, my findings indicate we still struggle with this. Case in point: most people don't use the advanced analytical features in Excel, like what-if analysis, power pivot, the formula tab, which includes Python, and the 'analyze data' button. What I've also learned on my journey is that we need to do better at collecting data and to the right level, as we've been stating for over 25 years (you a lot longer). More to come on this...
Regarding the TCM, when we meet to collaborate on the 3rd edition in Anaheim, data analytics and AI will be added as an enabling process.
Cheers,
Lance
------------------------------
Lance Stephenson
Director of Operations
AECOM
Edmonton
h.lance.stephenson@gmail.com
Original Message:
Sent: 01-24-2025 09:56 AM
From: John Hollmann
Subject: Project Controls Reimagined: Unlocking the Power of AI
Thanks for sharing. I am so happy to see TCM being taken to the next level (the renAIssance). Next year will be the 20th anniversary of the TCM Framework (and AACE membership maybe hitting 10K) so it is ripe for the analytics transition hitting us all. Thanks for your leadership on this Lance!
------------------------------
John Hollmann
Owner
Validation Estimating LLC
Ashburn
jhollmann@validest.com
Original Message:
Sent: 01-23-2025 03:03 PM
From: Christian Heller
Subject: Project Controls Reimagined: Unlocking the Power of AI
For those of you that missed this (excellent) presentation, here is a link to the recording (free to AACE members and non-members both):
Archived Webinar: Project Controls Reimagined: Unlocking the Power of AI [January 21, 2025]
------------------------------
Christian Heller
Director of Technical Guidance
AACE International
cheller@aacei.org
Original Message:
Sent: 01-22-2025 07:57 PM
From: Lance Stephenson
Subject: Project Controls Reimagined: Unlocking the Power of AI
Thank you... I can talk for hours on this stuff... and I can talk for days on non-related matters as well!!!
------------------------------
Lance Stephenson
Director of Operations
AECOM
Edmonton
h.lance.stephenson@gmail.com
Original Message:
Sent: 01-22-2025 07:31 PM
From: Lorne Bussell
Subject: Project Controls Reimagined: Unlocking the Power of AI
Hi Lance,
Thanks very much for your presentation yesterday, it was informative, engaging and to the point, I only wish it went for longer :)
Best Regards,
Lorne
------------------------------
Lorne Bussell
Functional Lead Planner
Alcoa
Booragoon
lorne.bussell@alcoa.com
Original Message:
Sent: 01-22-2025 02:48 PM
From: Lance Stephenson
Subject: Project Controls Reimagined: Unlocking the Power of AI
I've attached the slides from the AI webinar. Here is the link to the recording: https://www.pathlms.com/aace/courses/9229/video_presentations/337206.
------------------------------
Lance Stephenson
Director of Operations
AECOM
Edmonton
h.lance.stephenson@gmail.com