This blog is for Construction Professionals wherein I learn and share Project Management and Green Building Concepts. If you are passionate about learning and updating your Construction and real Estate related knowledge along with MS Excel and MS Project Skills just hang on..
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.
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.
questions that must be asked are.
Can one relate the process with basics?
Can you be creative and generate alternatives?
How does it handle integrated cost optimization and
quantitative risk management?
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.
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
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
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.
billing of buildingsMany 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 Excel 2007 or 2010. SKILL-1: NESTED
IFS To be sure that the c…