Posts

A solver Solution to resolve the incomplete housing inventory

Image
  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

Life Cycle Costing Updates

Image
Most of India's habitat and civil infrastructure is yet to be built. The existing ones need rehabilitation and to be built better. The " LiFE mission " without enabling and integrating the construction industry is incomplete.     The model above depicts an integration of the two and is considered the first practical step towards a circular economy. Civil Infra Life Cycle need to assimilate and integrate with LiFE.  The above model for  moving towards sustainability and the Circular Economy is an extension of the earlier p roposal in the  Azadi Ka Amrit Mahotsav conference on Indigenous Engineering Solutions . Does writing integration of LCC with the LiFE mission make sense when we have not even started with Life Cycle Costing in construction practice?

No Code Development in Construction Industry, Building Research and Sustainability

Image
 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

Image
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?

Image
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

Image
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.