Ashutosh

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

Charting in excel is mostly intuitive and easy. However sometimes it can be tricky. One such situation is when it is pertinent to show two supporting parameters which are quantitatively on different scales. Here you want to boast your team’s efficiency who have  increased their turnover (Value Created)  while cutting down their establishment costs.

Solver in Excel does what its name is. Like any other excel tool it is best learnt through an example. Let us look at stakeholder’s motives.  Builder’s motives are plain and simple profit maximization. Professional motives are a bit complex and difficult to formulate.  The Architect want space planning to meet his design vision. The Green Building Professional wants external façade to optimize daylight as well as thermal insulation. The structural and project Engineers want  the structure and construction process to be safe. The Project Management team is required to satisfy the needs of all the stakeholders.

'The Choice is simple Sustainable development, unsustainable development or no development at all.' Sandy Halliday, Build Green 1990." National Perspective Continuing with the conventional constructional technologies for the mass housing is like burning candle from both sides. It is unsafe, polluting, wasteful and may be.... undignified for our times. The negatives multiply in case of high rise construction wherein it is akin to burning candle from all ends. It is the root cause of the poor quality, Project Time + Cost overruns and most tragic of them all most fatal accidents. Indian construction Industry (?) can't afford to continue it  for mass construction projects. Planetary Perspective With the above perspective, achieving mission of Housing for all by 2022 through the present industry practices is likely to be disastrous not only for us but for the whole planet as well. For achieving Sustainable Development Goals (SDGs), it is imperative that w...