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..
on earth would one like to do structural and other construction related designs
using Excel? Are not there lot of software already? And most tend to get user
friendly and simplistic after a few repetitions.
answers to above are, that is why and more so! The software in use are black
boxes and don’t really connect with your conceptual engineering (first
principles) knowledge. And that is why you can’t be creative or audit it.
questions that must be asked are.
Can one relate the process with basics?
Can you be creative and generate alternatives?
How does it handle integrated cost optimization and
quantitative risk management?
any case, you require the designs to be cross checked with another software
application. And the knowledge worker within you would definitely like to
connect it with subject basics.
is fun to use advanced Excel skills to address the above. Building Green
demands creativity and innovation. Sustainability requires energy and material
to be used efficiently. Subsequent blogs shall make the elaboration of the
To begin with the single most important reason to adopt the MS Project is that activity sequencing with it is very easy. It is here assumed that your team is already using other MS office applications (2007 or later). The initiation of schedule preparation with MS Project would give rich dividends and justify additional cost and effort on this account only. In Indian scenario especially at locations where construction projects have suddenly grown both in size and complexities, gaining maturity in professional scheduling/work sequencing can be a boon. The construction projects scenario here can be summed up as below. 1. Projects are getting more complex. 2. Numerous sub consultants and subject matter experts are involved. 3. Construction Industry has a tradition of consultants working in silos. 4. Works have to be got done through subcontracting. if you have been in a complex building construction team, it is obvious to you that inadequate
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 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