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

  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

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

Using Excel Power query for Construction Billing & Data Mining

By -
 This blog published automating construction billing during 2013. It is tried and tested and customises, nested ifs, data validation, Vlookup and workbook protection skills to meet the accounting department's requirements. Excel since then has transformed into analyzing and visualizing the big data. Construction projects have also transformed. 2013 was the time when the dashboard became fashionable, it served the purpose. Now is the time for low code, no-code development  — dashboard remains in the front but the real value and not just automating a semi-manual billing that was inherited; what present-day site monitoring and management requirements are much beyond. Construction quality and safety as demanded today can be met by freeing the site engineers from all possible non-related activities. And meeting the requirements of construction data mining. 
Read more

BILLING WITH MS EXCEL (V-1)

By -
Image
For Construction billing of buildings Many ERP Solutions Require. 1.       Tower wise data (Required). 2.      Unit wise data (Required but may be relaxed ) Additionally the best billing practices (Procedure) require the process to be: 1.        Simple & easy to work with and understand. 2.   Transparent and Electronically Audit-able. 3. The important data such as BOQ item rates and material coefficients etc. should be  tamper-proof . HOW EXCEL CAN HELP? A few of Excel tricks can make you achieve all the above and more. This tutorial shall help you to achieve the best construction billing practices which are essential for effective SAP implementation and utilization of the data for project related time and cost analysis for Project Monitoring & Control. The good news is that you need not change your computer hardware or billing engineer though faster computer would help. It is assumed here that your billing engineer is already preparing the bills using
Read more