WHY DESIGN USING EXCEL?

By -
Why on earth would one like to do structural and other construction related designs using Excel? Are not there lot of software already? And most tend to get user friendly and simplistic after a few repetitions.
The answers to above are, that is why and more so! The software in use are black boxes and don’t really connect with your conceptual engineering (first principles) knowledge. And that is why you can’t be creative or audit it.
The questions that must be asked are.
  1. Can one relate the process with basics?
  2. Can you be creative and generate alternatives?
  3.  How does it handle integrated cost optimization and quantitative risk management?

In any case, you require the designs to be cross checked with another software application. And the knowledge worker within you would definitely like to connect it with subject basics.

It is fun to use advanced Excel skills to address the above. Building Green demands creativity and innovation. Sustainability requires energy and material to be used efficiently. Subsequent blogs shall make the elaboration of the above.  

Comments

  1. Digital ArnavApril 23, 2024 at 4:23 AM

    Upon completion of our Excel and Advanced Excel Training in Noida, you'll emerge with a solid understanding of Excel's advanced features and techniques, empowering you to streamline workflows, analyze complex datasets, and make data-driven decisions with confidence. Whether you're pursuing career advancement, seeking to boost productivity in your current role, or exploring new opportunities in the data-driven world, APTRON Solutions is your trusted partner in Excel mastery.

    ReplyDelete

Post a Comment

Popular posts from this blog

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

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

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