DSR 2025 (E&M) in Excel is now available*!
(Since 2010)
(for those who work smart , not just hard)
WELCOME TO INDIAN RAILWAYS AND MES CIVIL ENGINEERS !
Dear Civil Engineers of Indian Railways and MES,
Now you are suppose to use DSR - 2023 instead of your own SSRs for your estimates. Railway Engineers are to use CPWD DAR for rate analysis for tender justification. Higher authorities of MES will announce the percentage limit above or below the DSR 2023 for tender acceptance.
You may think you can prepare estimates and rate analysis using Excel files. But, excel files won't do any work and you need to copy, paste, put sl nos and set formulas etc., If you use the Application, you just need to enter item code and quantity and rest of the things will be prepared by the App (Estimates and rate analysis gives output in MS Excel). To know more, attend a free demo session (contact rambabujalli@gmail.com and schedule the live online demo)
Apps Download links:
Jalli's App -2023 (Civil) [with DSRs-2023/2021/2018] Alternate Link (if you are unable to download any file please mail me at rambabujalli@gmail.com)
Jalli's App - 2025 (E&M) (With DSR / DAR - 2025 (E&M) Alternate Link
Download a sample out file of the App (Please read the information given in the 'Read Me' sheet to unlock the file.
Members can : (Click here to apply for membership or drop an e-mail to rambabujalli@gmail.com)
Why membership is required when some excel files are available for free over internet ?
The files uploaded on internet are not upto date. Many correction slips are issued by CPWD from time to time and these corrections are not made in the available files. Whereas we update all our documents and the application as per the latest circulars or orders and keep you informed. CPWD changed the analysis procedure and many of the Engineers who are suppose to use CPWD procedures are not aware of the changes issued by CPWD. But we keep you informed. Membership fee is to be paid only once in life time.
Download DSR-2025 (E&M) in MS Excel (With Correction Slip No. 1)
Download DSR and DAR 2023 Civil in Excel
DSR 2022 (E&M) in MS Excel
DSR-2021 (Civil) (corrected up to CS-21) in MS Excel
e-measurement Book in Excel (for steel work also)**
e-measurement book in Excel (F.P.S.)
Details of measurements Sheet to upload to Jalli's App (for App users only)
Anyone Can :
Correction Slips to DSR-2021-Civil (CS-1 to CS-21) (in PDF) [Downloads : 520]
Download DSR-2020 (Horticulture) in MS Excel [Downloads : 615]
Download DSR-2018 (Civil) in MS Excel [Downloads : 5,176]
DSR - 2016 (Civil) in Excel [Downloads : 10,749]
DSR-2014 (Civil) in Excel [Downloads : 11,635]
DSR-2013 (Civil) in Excel [Downloads : 14,497]
List of Civil Items in Horticulture and their item codes (For App users only)
Corresponding output file of the App for the above DOM sheet
* * e-measurement book is a customized macro enabled Excel work book for recording measurements. It enables to enter Numbers column as '2x3' , '1x2x3x4' , 2+3/4 etc., For steel measurements just select dia and enter numbers (as m x n) and length. Quantity will be calculated in respective dia. column.
Salient features of Jalli's App :
Easy to use Windows application, runs on any System having Windows OS.
All the output comes in the form of neatly formatted, ready to submit Excel files with formulas.
Details of measurements prepared in Excel can be directly uploaded and get estimate.
Basic rates in Excel can be uploaded to Jalli's App and get rate analysis.
Non-schedule items can be added or can be uploaded to the App very easily for Estimate as well as Rate Analysis.
Major projects can be split into separate components and the separate estimates can be merged into single estimate (BoQ).
No need to remember any commands, codes and it is the most user friendly application.
No specific training is required. Users can learn using the App through Youtube videos.
Data can be carried in a pendrive from one system to another.
Application is updated periodically whenever there is a change in the procedure or correction slips are issued.
Some of the Output Excel Files Generated from Jalli's App :
Detailed Estimate (BoQ, Abstract) based on DSR-2023/2021 / 2018 / (2025 - E&M, Horti)
Preliminary estimate (Schedule based on PAR-2012/PAR-2020 and Abstract)
Details of measurements (Can be exported or imported)
Theoretical consumption of Cement, Paint Statements
Rate Analysis (Based DAR-2023/2021/2018 2025 (E&M and Horticulture)
Detailed estimate with Analysed Rates
Resource Analysis (Inventory)
Comparative Statement (both for item rate and percentage tenders)
Agreement Copy (BoQ )
Bill Schedules
Extra Item Statements
Deviation of Quantities Statements (CPWD format)
Test Check Statements
Comparative Statement with final bill quantities
Fair Rent calculations
Cost Index Calculations
Jalli's App author Sri Rambabu Jalli with Sri VB Gupta, PGM(BW), Sri Ganga Prasad CE(Civil) and trainees at RTTC, Pune
Inauguration of training programme at ALTTC, Ghaziabad
Memento Presentation by Sri VB Gupta, GM(Civil), ALTTC
Jalli's App author with Sri VB Gupta, GM-BS and other trainees at ALTTC, Ghaziabad
Inaguration of training programme at o/o CGMT, Bhopal
With CE(Civil) and SE(Civil) at Bhopal
Jalli's App author with Sri HC Kadam, CE(Civil) and other officers attended for training at Bhopal
Inaguration of training programme at RTTC, Nagpur
Demo session to officers at Nagpur
Jalli's App author with Sri SV Joshi, CE(Civil) , Sri Manish Shukla GM, RTTC and trainees at Nagpur
Addressing the trainees at Bengaluru in the presence of Sri Vijendra Kumar, CE(Civil) and Sri Chatar Singh, faculty ALTTC, Ghaziabad.
With trainees at Bengaluru .. ..
Inaugural function of Training programme by Sri AK Bansal, CE(Civil) for trainees at RGMTTC, Meenumbakkam, Chennai
Seminar at Bhubaneswar, Odisha..
Launch of ver. 2012 by Sri Neeraj Goel, CE(Civil), Hyd in the presence of Smt Nasreen Quadri CE(C)-L&B and other officers