Posts

Showing posts from 2013

BILLING WITH MS EXCEL (V-1)

Image
For Construction 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…

Data Validation

As a default, you can fill in just any text or Number etc. in any cell of your worksheet.
Databases 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.

LIFTS: PROJECT MANAGEMENT PERSPECTIVE

USER PERSPECTIVEFrom the perspective of the user, the waiting time and the travel time form important performance measurement criteria.For comfortable travel, the horizontal and vertical accelerations are to be controlled and  limited to industry norms.INDUSTRY TRENDS (ENVIRONMENTAL FACTORS)
The cost of the system increases with the speed and beyond certain speed the increase is exponential.Lift manufacturers make lift cars with their unique nonstandard sizes. This implies that the planning the lift brand has to be concluded before issue of GFC drawings for ground floor structure. This is a great schedule contradiction as the lift commissioning is the last activity.Big brands often force their contract conditions. Usually their representatives have least authority to deviate from company’s prescribed conditions.Service & Safety Issues: AMCs with the manufacturer is usual and safety and good services are provided by most of the reputed companies. Following safety features are usual.…