Ashutosh

Two primary concerns for construction professionals are the opacity of black-box software and the risk of AI hallucinations. Opting out of either technology is no longer realistic. Nevertheless, professionals of real standing must keep basing and defending their decisions on sound principles, hard-won experience, and verifiable results.   Excel, when used  with full visibility , lets us leverage AI and beat the hallucination curse. 

Excel has natively supported data extraction from text files and databases for over a decade. Still, the ability to directly import structured data from PDFs was a major milestone introduced in 2020 via Power Query.  Today, integrating Copilot makes this process frictionless. In a well-structured document, the AI does more than ingest raw numbers—it inherently interprets the underlying data, its broader significance, and the strategic logic behind the publication's intent. On that account, i.e., explaining the tables and how to use them for preliminary estimation, the CPWD's PAR2025 document (freely available on the   CPWD Publications | Document | Central Public Works Department, Government of India website ) passes the AI usability test. 

AI Will Not Replace Construction Professionals — It Will Empower Them While AI is transforming industries worldwide, it does not threaten the future of construction engineers and managers — it enhances it. Across the project lifecycle, AI will automate repetitive tasks, optimise scheduling, predict risks, and improve efficiency. This frees professionals to focus on what truly matters: complex problem‑solving, on‑site leadership, innovation, and the delivery of safer, more sustainable projects. Construction professionals who embrace AI as a strategic partner will be best positioned to lead this evolution. The opportunity ahead is not disruption— it is transformation. It is a chance to build better, faster, greener, and with far greater clarity than ever before.

Until recently, MS Excel and MS Project were the primary tools for construction managers. While these tools remain essential, the advent of AI has not only made them more accessible but also unveiled numerous innovative use cases that previous generations could only have dreamed of. This blog has historically explored potential use cases in construction projects and provided essential templates in their simplest forms, available in both MS Project and Excel formats—each ready for an AI-powered transformation. Let us start exploring possibilities.

The 3D Map feature in Excel allows us to quantify parameters with context to their location. In the figure, below the feature has been used to calculate the volume of water stored in a peri-urban lake.   

We have been using complex statistical methods to answer questions like — what the probability of is completing a project in a given timeframe?   We employed the critical path method, incorporating weighted average task durations and the standard deviation of each task, utilizing the mathematical formulas presented in our Project Management course materials. The average project duration is the sum of all the average activity times along the critical path.   Knowing the average project duration and the variances of activities along the critical path allowed us to calculate the probability of completing a project using standard statistical tables.  If you are not well-versed in statistical concepts, the methods outlined in textbooks for project management may appear overly abstract and complex .  In many situations, considering the possibility of alternative critical paths becomes crucial. This can lead to additional abstractions, making it challenging to com...