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 of Excel needs