Ashutosh

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.

Project Control: Using Excel Conditional Formatting for guiding rate negotiations in Comparative Statement. Project control requires that the various work packages are carried out as planned. Civil construction is typically based on approved building plan and specifications. In view of progressive elaboration of project, Item rate tenders are most prevalent and provide the transparency and flexibility to both the owner and contractor. Projects are always mired with some uncertainty and items and their quantities often deviate. Various known and unknown factors affect the prices quoted by a contractor. Success of the project greatly depend on the Project’s ability to negotiate the contracts at a mutually win-win cost, performance and time frame even in the face of uncertainties. Practice of defining a Project/ work package through a Priority matrix is a handy tool for exploring on the negotiation possibilities. Time Performance ...

Charting in excel is mostly intuitive and easy. However sometimes it can be tricky. One such situation is when it is pertinent to show two supporting parameters which are quantitatively on different scales. Here you want to boast your team’s efficiency who have  increased their turnover (Value Created)  while cutting down their establishment costs.