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`/((bond.aggrement_cost+bond.var_cost)/100000)*100,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 = 12 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 % )
UDRP-AF(Public Building)Passive IT NETWORK at SDRF Campus, Jollygrant,DehradunDehradunM/s Desta IT ServicesAF/88/PB/UDRP-AF1-20200
2-20200
3-20200
4-2020171.61
5-2020171.61
6-2020259.94
7-2020259.94
8-2020259.94
9-2020963.14
10-20201249.92
11-20201725.51
12-20201853.96
1-20211853.96
2-20211853.96
3-20212234.39
4-20212234.39
5-20212234.39
6-20215791.02
7-20215791.02
8-20215791.02
9-20215791.02
10-20215791.02
11-20215791.02
12-20215791.02
UDRP-AF(Public Building)SDRFDehradunM/s NKG Infrastructure LtdAF/01B/BC/PIU/PB/UDRP/20181-20190
2-20190
3-20190
4-20190
5-20190
6-20190
7-20190
8-20190.28
9-20190.28
10-20191.81
11-20193.77
12-20194.58
1-20205.72
2-20207.68
3-20209.97
4-202012.63
5-202012.63
6-202013.63
7-202013.63
8-202014.5
9-202016.71
10-202016.71
11-202020.17
12-202020.17
1-202122.5
2-202122.5
3-202128.31
4-202128.31
5-202128.31
6-202133.21
7-202137.34
8-202137.34
9-202140.25
10-202143.36
11-202147.83
12-202147.83
1-202252.99
2-202257.33
3-202267.46
4-202267.46
5-202275.2
6-202275.2
7-202275.2
UDRP-AF(Public Building)USDMADehradunM/S A.S EnterpriseAF/02/BC/PIU/PB/UDRP/20191-20200
2-20200
3-20200
4-20200.56
5-20200.56
6-20200.85
7-20200.85
8-20200.85
9-20203.15
10-20204.09
11-20205.65
12-20206.07
1-20216.07
2-20216.07
3-20217.32
4-20217.32
5-20218.47
6-202118.97
7-202123.46
8-202124.84
9-202126.14
10-202127.94
11-202127.94
12-202129.19
1-202231.55
2-202234.02
3-202236.85
4-202236.85
5-202239.45
6-202239.45
7-202239.45
8-202239.45
9-202239.45
10-202239.45
Chart's Height Chart's Width
Sort By % Progress Descending
Sort by Sub Project Name