Ashutosh

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?

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

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