A solver Solution to resolve the incomplete housing inventory

  Many solutions using the Excel solver tool as used in the field have been presented in this blog. The application ranges from structural design optimisation to revising weights to green building parameters . Solver works like magic; results are too good to be believed. Once you start using it, you understand problem formulations and asking the right questions as the only thing you ever need to know and develop. If you have never used solver, you would like to read a solver primer    first. Problem Statement Task Allocation optimisation to contractors' of specialised trade in the present scenario*. Assumption Tasks and skilled trade workforce are available in plenty. Constraints  Each contractor would take up only one or two tasks simultaneously. (They tend to grab many jobs, and all task's schedule and quality suffer as a result)  In the hypothetical problem in the sheet, " o ne Contractor 1 task, "  five tasks are allocated to five trade contractors.  Th

No Code Development in Construction Industry, Building Research and Sustainability

 A no-code development for Construction Billing was earlier demonstrated. The data model was restricted to the consolidation of Excel Billing files and an excel file containing theoretical consumptions of various basic inputs. The technique frees us from the tyranny of long looped Lookup formulas , the limitations of sheet rows, and how it slowed down the computer system.    However, Power Query's data extraction is not restricted to merely Excel files and folders. Here lies the opportunity to integrate the evolutionary knowledge of sustainability into construction practices and research.  In the current illustrative solution, a relevant table in the updated ECBC code, freely available on the BEE website, has been converted into a sort of App in just one sitting...and typing no code. You can download the Excel file here and the presentation showing the stepwise development of the table into a lookup-like app here . The application uses Power Query and your version of Excel needs

Indigenous Engineering Solutions in Construction, Green Buildings and Sustainability

Historically, Governments have been deriving the construction Industry. In India CPWD a premier construction agency, also performs a regulatory function in setting the pace and programmes for the building industry 1 . As a part of Azadi Ka Amrit Mahotsava, a National Conference on "Indigenous Engineering Solutions in Construction of a self-Reliant India" was organised by the National CPWD Academy. Compendium of conference papers is now available on the National CPWD Academy's website.   

Why we shiver inside an old passively oriented Building?

Why during winters, does it feel colder inside an old passively built habitat? And what can improve it? Yes, at present the Delhi NCR is undergoing extreme heat, the corona epidemic has forced us all to stay indoors. One is lucky to reside in a passively oriented low-rise habitat with grown-up trees. But those in high-rise apartments without passive orientation have to bear the burnt.

Sustainable Construction-Issues and Solutions

 This blog does not involve complicated simulations. Instead, it attempts to identify sustainability issues in the  Indian urban development context. All constructions are bad for the environment— considering our immense shortage we ought to build in a big way— but our building activities must show this sensitivity.

Construction Billing with Excel Update

MS Excel has been used for construction billing from the very beginning of its launch. Excel 2007 with the introduction of Pivot tables made calculations like abstracts appear like magic. Other calculations like theoretical cement consumption etc. were also possible and yet total automation was not possible. Power Query and Power Pivot an addon to Excel 2010 were initially inaccessible have come of age now. The users of this blog would like to visit "Billing with MS Excel (V-1)" to see the possibilities of using pre-2013 Excel versions. The new data capabilities make Excel a gamechanger for billing and similar applications. Please look at the possibilities of this tutorial.

Using Excel Power query for Construction Billing & Data Mining

 This blog published automating construction billing during 2013. It is tried and tested and customises, nested ifs, data validation, Vlookup and workbook protection skills to meet the accounting department's requirements. Excel since then has transformed into analyzing and visualizing the big data. Construction projects have also transformed. 2013 was the time when the dashboard became fashionable, it served the purpose. Now is the time for low code, no-code development  — dashboard remains in the front but the real value and not just automating a semi-manual billing that was inherited; what present-day site monitoring and management requirements are much beyond. Construction quality and safety as demanded today can be met by freeing the site engineers from all possible non-related activities. And meeting the requirements of construction data mining.