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 the visual confirmation of snapshots would expedite and transform decision making. Project management agility requires that all stakeholders especially the client are engaged in the design. Here your decisions can be validated even by 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. Daylight optimization has been done with optimal window size and shading that cuts direct sunlight to cutting glare at the minimum first cost. The client and the multidisciplinary project team need 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

  1. saivenkatAugust 2, 2020 at 8:42 PM

    That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.

    Best Project Management Software

    ReplyDelete
  2. shademattersSeptember 25, 2020 at 8:35 AM

    A lot of valuable information can be derived from the post. we provide ready made shade sails at affordable cost. for more info visit our website.

    ReplyDelete
  3. digitalhtsDecember 18, 2020 at 11:50 PM

    I read your blog. it is really helpful and knowledgeable. Carry on. Keep blogging. otherwise anyone wants to learn MIS training course so Contact here- +91-9311002620 or visit website- https://www.htsindia.com/Courses/business-analytics/mis-training-instiute-in-delhi

    ReplyDelete
  4. digitalhtsDecember 19, 2020 at 12:26 AM

    I read your blog. it is really helpful and knowledgeable. Carry on. Keep blogging. otherwise anyone wants to learn Revit MEP training course so Contact here- +91-9311002620 or visit website- https://www.htsindia.com/Courses/cad-cam-cae/autodesk-revit-mep-training-course

    ReplyDelete

Post a Comment

Popular posts from this blog

Indigenous Engineering Solutions in Construction, Green Buildings and Sustainability

By -
Image
Historically, Governments have been deriving the construction Industry. In India CPWD a premier construction agency, also performs a regulatory function in setting the pace and programmes for the building industry 1 . As a part of Azadi Ka Amrit Mahotsava, a National Conference on "Indigenous Engineering Solutions in Construction of a self-Reliant India" was organised by the National CPWD Academy. Compendium of conference papers is now available on the National CPWD Academy's website.   
Read more

Application for Making Parabolic Camber Board

By -
This Excel Application Calculates the Points for making a parabolic camber Board and draws a chart for the half road section profile. You are required to enter the road width and the % slope. The parabolic shape is given so that the profile is flat at the middle and steeper towards the edges, which is preferred by the fast moving vehicles as they have to frequently cross the crown line during overtaking operations.  on a two lane highway. Download Application here.
Read more

PERT Simulations- How New Excel Functions Enable Transparency.

By -
Image
We have been using complex statistical methods to answer questions like — what the probability of is completing a project in a given timeframe?   We employed the critical path method, incorporating weighted average task durations and the standard deviation of each task, utilizing the mathematical formulas presented in our Project Management course materials. The average project duration is the sum of all the average activity times along the critical path.   Knowing the average project duration and the variances of activities along the critical path allowed us to calculate the probability of completing a project using standard statistical tables.  If you are not well-versed in statistical concepts, the methods outlined in textbooks for project management may appear overly abstract and complex .  In many situations, considering the possibility of alternative critical paths becomes crucial. This can lead to additional abstractions, making it challenging to com...
Read more