Steps to be followed for using DATA TOOL:

1.Download and install the SaveAsPDFandXPS.exe file - (file is available in zip format)
2.Enable "macros" after opening the Excel file. macro security level should be kept as "LOW"
3.INPUT the relavent "Datas" and OK them.
4.Use PRINT option to print all the data formats.
5.Use EXPORT option to save the file in "pdf" format.
6.While exporting,file will be saved in "C", and Please Rename the file.
7.After saving the File,take printout of the required Data formats.
8.Password--highways,open the file as "Read only" and use it.
9.For any queries,Please contact AD,RMS.

Modification done in latest version (V 1.3 - 26.09.2012)

1. extra allowance for material, work, labour component for corporations, hills as in PWD schedule of rates,
2. night work component in city roads division
3. conveyance factor beyond 40 km - from 4.9 to 4.5
4. Bitumen VAT calculations
5. Bitumen lead
6. CRM - lower most metal size from 0.0066cum to 0.066 cum
7. data for tack coat over bm/dbm - added

Modification done in V 1.4

1. water cost added in WMM
2. corrections to extra allowances for metal, labour, work and head load
3. corrections in some of the titles

Modication done in V1.5
1. SDBC using mini hot mix plant - bitumen qty from 27 kg to 28 kg.
2. added data for prime coat over CRM
3. ADDED DATA FOR TACK COAT OVER DLC
4. BC rate per cum added

Modication done in V1.6
1. DATA FOR DLC 1:4:8 (MIX IN PLACE) ADDED
2. ERROR IN EXPORTING TO PDF IS CORRECTED

Modication done in V1.7
1. Basic rate of cement and steel corrected to accomodate storage charges
2. Option given to save the "Abstract Data" for linking it to main estimate
3. data 9m paver finisher added for city roads division
4. "selective printing" option is given

