Useful Chart for a Construction Manager

By -
Charting in excel is mostly intuitive and easy. However sometimes it can be tricky. One such situation is when it is pertinent to show two supporting parameters which are quantitatively on different scales.

Here you want to boast your team’s efficiency who have  increased their turnover (Value Created)  while cutting down their establishment costs.
Usual parameter which shows the team's efficiency is E/T ratio which is only a fraction of your turnover and therefore when you try charting with a routine XY chart is not visible or not indicative of this trend.
When the new recommended charts feature in Excel 2013 version does not help you you try XY charting. Though all three series are addressed it does not communicate your intent, that is to project your enhanced value creation while reducing expenditure on your establishment.


The trick here is to show the E/T on the secondary axis which needs to be communicated to Excel by you. So, you select and delete the Establishment series which is not pertinent. Now you need to move the E/T series to secondary axis. So you select this series and in the format data series  Series option choose Plot Series on Secondary axis to get the desired intent.


It is a good idea to get used to Excel Charting jargon. You can download the example by clicking A useful Chart for Construction Manager.

Comments

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

Excel Basics for Construction Professionals

By -
The following blog and attachments are on an Excel Workbook that I use for my introductory classroom sessions on Excel for Construction Professionals. In a time when social distancing is prescribed, it would be better if the tool makes one learn on its own. The present one still requires a class supplementation, and I need your perspective on making it more useful.
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