Filter Options >> Progress criteria: Project:District:Contractor:DEA:There are no valuesPackage Name:There are no valuesNo.of Sub Project:Sub Project:

Page 1 of 1

SELECT A.countt,master_dea.`project`, `modified_sheet1`.`uid`, modified_sheet1.`road_name_english`,`modified_sheet1`.`district_name`, contractor.`contractor_name`,modified_sheet1.`package_name`, CONCAT(expenditure_cum_monwise.`mon`,'-',expenditure_cum_monwise.yrs)monthyear, ROUND(`expenditure_cum_monwise`.`cumulative_expenditure`,2)per_pro FROM`mkb_wb`.`expenditure_cum_monwise` INNER JOIN `mkb_wb`.`modified_sheet1` ON (`expenditure_cum_monwise`.`uid` = `modified_sheet1`.`uid`) INNER JOIN `mkb_wb`.`bond` ON (`modified_sheet1`.`work_package_no` = `bond`.`package_no`) INNER JOIN mkb_wb.`master_dea` ON (master_dea.`project_code`=bond.`project`) INNER JOIN mkb_wb.`contractor` ON (`contractor`.`contractor_id`=bond.`contractor_id` ) INNER JOIN ( SELECT COUNT(uid)countt,uid FROM mkb_wb.expenditure_cum_monwise WHERE `expenditure_cum_monwise`.`progress_date`<=NOW() GROUP BY uid )A ON A.uid=modified_sheet1.`uid` WHERE 1=1 and modified_sheet1.project_code = 10 AND `expenditure_cum_monwise`.`progress_date`<=NOW() ORDER BY master_dea.`project_code`,modified_sheet1.`road_name_english` ,expenditure_cum_monwise.yrs, expenditure_cum_monwise.`mon`
ProjectSub projectDistrictContractorPackage NameMonth-YearFinancial Progress
( in lacs )
UDRP-AF(RBP)Alakapuri Kathiyal Sain AlaknandaChamoliGSCO Infrastructure Pvt Ltd.UDRP/AF/RBP/0211-20180
12-20180
1-20190
2-20190
3-201938.93
4-201938.93
5-201991.84
6-201991.84
7-2019150.35
8-2019150.35
9-2019150.35
10-2019150.35
11-2019150.35
12-2019150.35
1-2020150.35
2-2020336.54
3-2020359.57
4-2020359.57
5-2020458.38
6-2020458.38
7-2020458.38
8-2020458.38
9-2020458.38
10-2020458.38
11-2020458.38
12-2020623.65
1-2021655.23
2-2021762.05
3-2021964.02
4-2021964.02
9-20211051.6
UDRP-AF(RBP)Banswara MandakaniRudraprayagChaudhary Sandeep Contractor & SuppliersUDRP/AF/RBP/071-20200
2-20200
3-20200
4-20200
5-20200
6-20200
7-20200
8-20200
9-20200
10-20200
11-20200
12-20200
1-20210
2-202167.23
3-2021125.52
4-2021125.52
5-2021194.49
6-2021194.49
7-2021229.55
8-2021229.55
9-2021229.55
10-2021229.55
11-2021229.55
12-2021229.55
1-2022328.08
2-2022328.08
3-2022419.93
4-2022419.93
5-2022460.89
UDRP-AF(RBP)Birahi Village RB AlaknandaChamoliBharat ConstructionUDRP/AF/RBP/0411-20180
12-20180
1-20190
2-20190
3-2019124.71
4-2019183.15
5-2019330.8
6-2019430.96
7-2019430.96
8-2019430.96
9-2019430.96
10-2019430.96
11-2019430.96
12-2019430.96
1-2020430.96
2-2020486.96
3-2020547.55
4-2020547.55
5-2020768.35
6-2020768.35
7-2020768.35
8-2020768.35
9-2020768.35
10-2020768.35
11-2020768.35
12-2020945.33
1-20211037.25
2-20211488.7
3-20211712.29
9-20211795.66
UDRP-AF(RBP)Dewali RB AlaknandaTehriBharat ConstructionUDRP/AF/RBP/0511-20180
12-20180
1-20190
2-20190
3-2019171.79
4-2019171.79
5-2019171.79
6-2019320.88
7-2019320.88
8-2019320.88
9-2019320.88
10-2019386.75
11-2019386.75
12-2019518.75
1-2020518.75
2-2020839.59
3-20201127.26
4-20201127.26
5-20201287.87
6-20201287.87
7-20201287.87
8-20201287.87
9-20201287.87
10-20201302.84
11-20201517.86
12-20201734.06
1-20211752.23
2-20211905.99
3-20212229.94
4-20212229.94
5-20212229.94
6-20212229.94
7-20212229.94
8-20212229.94
9-20212297.23
10-20212297.23
11-20212297.23
12-20212297.23
1-20222297.23
2-20222297.23
3-20222316.5
4-20222316.5
5-20222325.79
UDRP-AF(RBP)Maithana AlaknandaChamoliM/S Ajay kumar contractorUDRP/AF/RBP/081-20200
2-20200
3-20200
4-20200
5-20200
6-20200
7-20200
8-20200
9-20200
10-20200
11-20200
12-20200
1-20210
2-20210
3-2021407.87
4-2021407.87
5-2021407.87
6-2021535.81
7-2021668.41
8-2021668.41
9-2021668.41
10-2021668.41
11-2021668.41
12-2021668.41
1-2022668.41
2-2022668.41
3-2022887.2
4-2022887.2
5-20221045.37
Chart's Height Chart's Width
Sort By % Progress Descending
Sort by Sub Project Name