Jalli's App - The Civil Estimation, Rate Analysis, Billing Software Application
(for those who like to work smart, not hard!)
"I choose a lazy person to do a hard job. Because a lazy person will find an easy way to do it.” - Bill Gates
Youtube videos on Rate Analysis using Jalli's App
Downloads Section :
Download : Jalli's App -2023 (Civil) [with DSRs-2018/2021/2023] Jalli's App 2020-Horticulture Jalli's App - 2022 (E&M)
Download DSR-2023 (Civil) in MS Excel (dated 04.05.2024) [Downloads : 2,232]
Download Sample Estimate generated from the App (Govt. model) *
Download DSR-2021 (Civil) in MS Excel (corrected up to CS-21) [Downloads : 4,329]
Correction Slips to DSR-2021-Civil (CS-1 to CS-21) (in PDF) [Downloads : 423]
DSR 2022 (E&M) in MS Excel [Downloads : 640]
Download DSR-2020 (Horticulture) in MS Excel [Downloads : 474]
Download DSR-2018 (Civil) in MS Excel [Downloads : 4,822]
Download DSR-2018 (E&M) in MS Excel [Downloads : 581]
*user had created the DOM sheet and uploaded to App and this is the final output.
other Downloads :
DSR - 2016 (Civil) in Excel [Downloads : 10,661]
DSR-2014 (Civil) in Excel [Downloads : 11,620]
DSR-2013 (Civil) in Excel [Downloads : 14,477]
e-measurement Book (Excel)* [Downloads : 3,802]
e-measurement book in Excel (F.P.S.)** [Downloads : 331]
Details of measurements Sheet to upload to Jalli's App (for App users only)
Multiplication Factor Calculation for GST Component in Rate Analysis (0.1405 or 0.2127)
Modification factor to be applied on DSR-21 due to change in GST or CP OH (Calculation)
Modification factor for CP & OH 10% instead of 15% for BSNL estimates
(All downloads are counted up to 16th November, 2024)
* 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.
** e-measurement book (FPS) is useful when you are using FPS system i.e. using feet and inches in linear measurements.
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
Preliminary estimate (Schedule based on PAR-2012/PAR-2020 and Abstract)
Details of measurements
Theoretical consumption of Cement Statement
Rate Analysis (Based DAR-2023/2021/2018)
Detailed estimate with Analysed Rates
Resource Analysis (Requirement of all materials for the project with detailed calculations)
Comparative Statement (up to 99 agencies)
Agreement Copy (BoQ )
Bill Schedules
Extra Item Statements
Deviation of Quantities Statements
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