Simple Visualization of Sun,facade, Window and Shade

By -
The raison d'etre of using Excel for designing/ decision making is that the solution is not a black box and professionals besides relating to basic principles can play with it through and create scenarios. Transparency of formulas and correlations when supported with basic visualizations however can authenticate decision making.



Seeing is believing. Optimal solar passive design requires varying requirements.

The transparent quantification when supported through visual confirmation of snapshots would expedite and transform decision making. Project management agility requires that all stakeholders specially the client are engaged in the design. Here your decisions can be validated even by a laymen.
Newer versions of Excel are focusing on visualization as well. 

Problem Definition:- 

Decision on solar passive optimization (considering 8760 hours) have been taken through trade-offs for creating shading during summer months and allowing the sun during winter months. Day light optimization have been done with optimal window size and a shading that cuts direct sunlight for cutting glare in the minimum first cost. The client and the multidisciplinary project team needs to be presented and convinced through a visualization that they can validate.

Please visit my earlier blog for background. The solution has been further simplified by following the formulas and conventions in the book “Introduction to Architectural Science: The Basis of Sustainable Design” by  S. V. Szokolay.

Please download the workbook here, experiment and comment. You need to know some basic building science.  Use Excel 2016 to make the best of the application.


Location: New Delhi, Delhi, India

Comments

Post a Comment

Popular posts from this blog

Using Excel Solver Feature to analyze and optimize the Steel Truss Design.

By -
Image
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

Read more

Project Scenarios-What if Analysis

By -
Image
Project conception and monitoring involve estimation risks. Estimates are uncertain. Expert judgement is used to quantify these.  However hard we plan, there would always be some random variations. Let us explore the “what if” in the forecast group at data tab.  Scenario manager here is helpful in creating various project (probable) outcomes.   This concept is best understood using an example. Click here to download the workbook. You need to solve it to get a grip over it. Do the followings. Use “Goal seek” to create the various break-even quantitiesUse “data table” to vary two variables at a timeCreate a “Scenario Summary” with most likely, Optimistic and Pessimistic quantities.Run Monte Carlo simulation.
These tricks allow great possibilities to a problem solver. Your comments to simplify and further explore it are welcome.


Read more

Using Excel conditional formatting for comparative statements

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

Time Performance Cost Constrain

X Enhance X  X
Accept


Figure-1 Project/ work Priority…
Read more