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

Decision Making Through Life Cycle Costing- A Simple Practical Example

By -
Decision Making Through  Life Cycle Costing- A Simple Practical Example Problem Statement: To compare the life cycle costing by calculating the single Present  Value for different scenarios. A choice is required to be made for air conditioning by Installing AC only Installing AC along with insulation works and solar film . The variables would be the Initial costs and the Cost of Capital. The link below would take you to the Excel worksheet wherein the comments in each cell would make you understand the process fully. It is assumed that the user is a knowledge worker and the input parameters have been evaluated through experts. Excel Workbook has been set in a manner that is fit for a novice excel user. Download The Excel File Related Article - THE ECONOMY OF ENERGY EFFICIENT BUILDINGS; AN INDIAN PERSPECTIVE
Read more

WHY USE MS PROJECT FOR SCHEDULING AND MONITORING CONSTRUCTION PROJECTS?

By -
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
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
Read more