Ashutosh

Project management theory has advanced tremendously over the last generation. In practice, however, it has often fostered overconfidence and contributed to failure. Construction contracts frequently require submission of a project schedule in MS Project or Primavera, yet these documents often become little more than a paper formality with limited ongoing use.

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.