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..
a default, you can fill in just any text or Number etc. in any cell of your
and solutions however demand reliability.
The Data validation feature just does that. For example you might want
to dictate the following rules to your electronic measurement book.
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
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.
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