Foreword

It is important that premier organization like CPWD works on a roadmap of systematic introduction of e-governance to achieve its long term goals through IT initiatives. The main objective of introducing IT in an organization is to bring efficiency and transparency in its core functions enabling it to serve better. CPWD needs specific softwares to help its employees to execute works as well as support management to monitor various projects and its assets maintenance and management services. Various applications and programs have already been introduced in CPWD like Project management system(PMS) for monitoring of progress of works, Personnel Information Management System(PIMS) for human resource management and CPWD sewa for maintenance services to name a few.
In this context it was felt necessary to arm the functionaries of the department with suitable software that will improve its productivity in preparation of estimates, NITs, tender processing etc. With this background a software CPWD Planning Application (CPA) based on DSR 2007 has been developed which will substantially reduce cycle time of planning activities. The software integrates the useful features and facilities generally needed in planning offices. This will also enhance capability of the employees to utilize IT based systems in CPWD.
This version of software is being released for use in their day to day functions and feedback. Various suggestions for its improvement and modifications that are considered necessary may be intimated to Central Design Organisation.
I wish to place on record the effective co-ordination on the part of Sh.R,N,Dandekar Chief Engineer (CDO) and sincere efforts and dedication put in by Sh.V.Jithender Reddy, Exe. Engineer Nagpur Central Division-II, CPWD in developing this software.

March 2009


D.S.Sachdev

Director General (Works)
CPWD, New Delhi



Preface

CPWD has already embarked on adopting strategy of computerization to bring about total quality management in its various functions by making use of IT enabled services. Use of PCs has already percolated down to the level of division and subdivisions.
CPWD’s core function rests in creating built environment for various departments of central government for which estimation and tender evaluation is the basic activity in various planning offices as a precursor to execution of works. Preparation of detailed estimates, NITs, tender documents and justification if done manually is highly laborious and time consuming activity in which possibility of committing errors can not be ruled out. CPWD has been making use of software named as Integrated Planning Application originally based on DSR 1997 and subsequently its updated version based on DSR 2002 for planning activities. This software was very well received in the department.
With the introduction of DSR 2007, requests have been pouring in for release of software based on DSR 2007. Accordingly CPWD Planning Application has been developed in house based on latest dot net technology with user friendly graphical interface. Apart from basic function of preparation of estimates and justification additional features as listed under salient features below, have also been incorporated in this software.
It is sincerely felt that this software will fulfill long awaited requirement of planning offices. Although this version of software is complete in itself with all facilities as listed under salient features, but is being released on trial for getting feedback from users. It is requested to use the software and problems if any and suggestions for its further improvement may be informed to me for incorporation in its subsequent versions which will be made available on CPWD website.
The software has been solely conceived and developed by Sh. V. Jithender Reddy, Executive Engineer Nagpur Central Division-II, CPWD. Dedicated efforts of Sh. Reddy are highly appreciated.
 

March 2009


R.N. Dandekar
Chief Engineer (CDO)
CPWD, New Delhi



Developer's note

VJReddyPhoto

In CPWD, preparation of estimate, NIT, comparative statement and justification is the activity before award of work and takes lot of time if done manually. Earlier Integrated Planning Application (IPA) based on DSR 2002 and DAR 1997 was being used for preparation of estimates, justification etc. With the introduction of DSR 2007 by revising DSR 2002 and DAR 2007 by revising DAR 1997, there is an imminent need for the software based on DSR 2007 and DAR 2007.
Hence, I have developed the CPWD Planning Application (CPA) software ab initio, using the latest Object Oriented Programming with .NET framework to prepare estimate, NIT, tender document, comparative statement, justification etc based on DSR 2007 and DAR 2007. I have tried to make the program as user friendly as possible with easy learning curve and made several visual enhancements so that one can get a clear picture easily.
I express my gratitude to Sri D.S. Sachdev, Director General (Works), CPWD and I express my sincere thanks to Sri R. N. Dandekar, Chief Engineer, CDO, CPWD for taking keen interest and making it possible to circulate this software to all CPWD offices.
Even though every effort has been made to see that the program is error free, the users are requested to check the input and output from the program properly when the program is used. However, if any error is observed please mail it to CPWDPlgApp@gmail.com with subject as ERR: followed by brief description of the error and if any suggestion is to be made please mail it to CPWDPlgApp@gmail.com with subject as SUGN:followed by brief description of suggestion. I hope that this software will serve the intended purpose and reduce the time consumed in the planning activities.

March 2009

V. Jithender Reddy
Executive Engineer, NCD-II
CPWD, Nagpur


Salient Features of CPWD Planning Application (CPA)

  • Modified DSR items and Non Schedule Items can be entered including analysis of rates, so that the analysis can be used for the justification of rates. To reduce typing work the item and analysis of rate data from another existing item can be copied to other items and then modified as required. The analysis of rates of modified DSR and Non Schedule items can be copied to the estimate, so that when the estimate is sent another office the justification can be done for these items even though the analysis of rates of these items is not present in the master database of that office.
  • There is flexibility in feeding the analysis of rate to enter mathematical formulas, sub analysis items etc.
  • Items are listed in the descending order of percentage of estimated cost along with the cumulative percentage, so that the items up to 90% of estimate cost can be selected easily for justification. If the user does not want to enter the analysis of rate for non schedule / modified schedule items, then the justified rate can be directly entered for justification. The program indicates by color coding the user entered justified rates.
  • Percentage of each item is worked out and bar chart is displayed and it can be sorted by the user. This gives an idea of weightage of different items in the estimate. Percentage of schedule items over the total estimated cost is also displayed as a bar to give an idea that the program is dominated by schedule items or non schedule items.
  • Reports of abstract of cost, detailed estimate, list of basic rates for justification, comparative statement, justification statement etc. can be printed in the same format as being used in the department including the (designations) stamps of offices.
  • Three levels of security is provided. The DSR items, DAR and basic rates for DAR cannot be added, deleted or modified by either by the admin user or the normal user. The modified schedule items, NS items and analysis can be added, deleted or modified by the admin user. Apart from this, the data which is stored in master database like cost index data, contractors data etc. can be created and modified only by the admin user. The normal user cannot save any data to the master database. This has been provided to have better security and to avoid any change in the DSR, DAR and basic rates for DAR either intentionally or unintentionally. If any correction slip is issued for these, the changes will be made and the corrected database will be posted on CPWD website for download.
  • After entering the data, the estimate can be locked to avoid unwanted modifications.
  • Estimate can be created from a template file, so that the commonly required options can be stored in the template to save time.
  • The estimate items and modified schedule and non schedule items can be imported from excel compatible spreadsheet, but only by the admin user.
  • Back up of estimate can be created and all the files are neatly organized in folders.
  • The items can be filtered based on item type, selection, subhead, words in the description of the item and the filtered items will be displayed in the table.
  • Estimate, schedule of quantities for NIT, list of basic materials can be exported to excel compatible spreadsheet. After receiving the market rates in spreadsheet, the market rates can be imported from spreadsheet for justification.
  • Color highlighting is provided to easily identify the DSR, Non Schedule items, selected items, items with quantity blank etc.
  • NIT including CPWD-6, CPWD-8 form and schedule of quantities is generated in word format. The user can edit the template file to modify the NIT template as per the requirements. It can be later used for preparation of tender documents.
  • The user can create other word format template files eg. covering letters, tender forwarding memo, TS memo etc. using the parameters defined by the program and user defined parameters for creation of other reports in word format.
  • Program comes with a word compatible component and excel compatible spreadsheet component so that the reports can be viewed and saved evenif MS office is not installed. The saved documents can be opened in MS office 97-2003, 2007, Openoffice.org, staroffice. This gives better compatibility, as this does not impose restriction of specific version of MS office for import and export of excel and word reports.
  • The estimate prepared on one computer can be viewed, checked and edited from another computer connected in network
  • The total quantity and amount of basic material and labour is worked out. The basic material and and labour required for each item and the itemwise break up of the basic material and labour can be viewed