Ashutosh

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.

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. ...

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. 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? 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 ...

For Construction billing of buildings Many 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....

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.

USER PERSPECTIVE From 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. ...

The paper coauthored with Anagh  has been published in the proceedings of National Level Symposium (Festival of Architecture & Built Environment-10th &11th Feb. 2012) organized by SRM University, Chennai.   (ISBN: 978-81-8424-755-8 Published by Allied publishers private Limited-Chennai)   Energy Saving By Optimizing Facade Elements with  Spread Sheet Model. Abstract: A major component of energy requirements for cooling and heating  comes through facade elements of a habitat. Bulk of this huge energy requirement can be  reduced through optimum orientation and detailing of building facade elements. The  graphical methods available for calculating the energy inputs are lengthy and cumbersome. Hourly heat ingress or loss quantification over the year makes such manual methods   impractical. The popular energy software are black boxes requiring inflexible and voluminous  data entries and are not suited for optimizing ind...