This blog is for Construction Professionals wherein I learn and share Project Management and Green Building Concepts. If you are passionate about learning and updating your Construction and real Estate related knowledge along with MS Excel and MS Project Skills just hang on..
a default, you can fill in just any text or Number etc. in any cell of your
and solutions however demand reliability.
The Data validation feature just does that. For example you might want
to dictate the following rules to your electronic measurement book.
Using Excel Solver Feature to analyze and optimize the Steel Truss Design.
If you are a Structural Designer and an advanced excel user, you might have or would like to use Solver Add in in Excel to optimize various designs.This feature is a paradigm shift from one way traditional design methods. Here, you make Excel try numerous design options/ possibilities till it meets all codal provisions for safety etc. and is also most economical. But I would like to warn the new professional that there is no substitute to getting deep into the design process and asking right questions from the professional peers and industry stakeholders.
For why you should design with excel please refer to my previous blog at http://www.ashutoshp.in/2014/01/why-design-using-excel.html
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.
The paper coauthored with Anagh has been published in the proceedings of National Level Symposium (Festival of Architecture & Built Environment-10th &11th Feb. 2012) organized by SRM University, Chennai.(ISBN: 978-81-8424-755-8 Published by Allied publishers private Limited-Chennai) Energy Saving By Optimizing Facade Elements with Spread Sheet Model. Abstract: A major component of energy requirements for cooling and heating comes through facade elements of a habitat. Bulk of this huge energy requirement can be reduced through optimum orientation and detailing of building facade elements. The graphical methods available for calculating the energy inputs are lengthy and cumbersome.Hourly heat ingress or loss quantification over the year makes such manual methods impractical. The popular energy software are black boxes requiring inflexible and voluminous data entries and are not suited for optimizing individual facade elements.