Analysis Master List

Sequenced by BOQ ID No.

Home Import Excel Add Analysis
ID BOQ Item Name Sale Amount Budget Amount Mat Sub FW P&M PRW Total Analysis Variance View
1 [CS.1.2.1] Soil Excavation 2,974,704 1,730,970 0 1,730,970 0 0 0 1,730,970 +0
2 [CS.2.1] ATT 4,114,017 2,420,010 0 2,420,010 0 0 0 2,420,010 +0
3 [CS.3.1] Back filling within site 752,337 441,315 0 441,315 0 0 0 441,315 +0
4 [CS.3.2] Back filling from out side 29,876,979 20,409,322 14,456,603 5,952,719 0 0 0 20,409,322 +0
5 [CS.4.1] M5 PCC 3,073,185 2,089,822 1,627,500 9,030 0 285,891 167,400 2,089,822 +0
6 [CS.4.2.A] M7.5 PCC 15,875,691 10,794,788 8,306,090 194,946 0 1,446,671 847,080 10,794,788 0
7 [CS.4.3.A] M20 RCC 426,525 290,034 235,400 1,019 0 33,815 19,800 290,034 +0
8 [CS.4.3.C] M30 RCC 47,899,142 32,573,266 26,640,467 116,526 0 3,668,330 2,147,944 32,573,266 +0
9 [CS.4.3.D] M35 RCC 48,745,295 33,145,741 27,293,835 116,494 0 3,617,330 2,118,082 33,145,741 0
10 [CS.4.3.F] M45 RCC 172,264,431 117,140,570 98,298,852 382,137 0 11,642,477 6,817,104 117,140,570 +0
11 [CS.4.3.G] M50 RCC 13,782,834 9,372,576 7,916,024 30,702 0 899,285 526,565 9,372,576 +0
12 [CS.4.3.J] M65 RCC 37,926,980 25,790,313 22,466,109 73,920 0 2,049,957 1,200,326 25,790,313 +0
13 [CS.4.4.A] All Grade RCC 5,935,138 3,481,948 0 0 0 0 3,481,948 3,481,948 +0
14 [CS.5.1.A] Formwork - Conv. 108,415,202 63,727,564 0 0 33,310,967 3,213,878 27,202,720 63,727,564 +0
15 [CS.6] Formwork - Conv. 2,249,740 1,323,377 0 0 0 0 1,323,377 1,323,377 +0
16 [CS.7.1.A] Reinf. Steel 386,809,975 302,712,666 267,895,947 1,413,075 0 5,630,892 27,772,750 302,712,664 +2
17 [CS.8.1.A] Structural Steel 3,687,724 2,885,968 1,922,288 862,240 0 101,440 0 2,885,968 +0
18 [CS.9.1.1] 100mm AAC Block 800,371 470,366 280,899 0 0 28,752 160,716 470,366 +0
19 [CS.9.1.2] 200mm AAC Block 9,100,848 5,349,913 3,477,725 0 0 362,777 1,509,410 5,349,913 +0
20 [CS.9.1.3] 250mm AAC Block 8,123,248 4,775,090 3,131,447 0 0 335,315 1,308,328 4,775,090 +0
21 [CS.9.2.A] 115mm Brick Work 624,800 367,336 225,641 34,028 0 18,061 89,600 367,331 +5
22 [CS.9.3.A] 230mm Brick Work 1,097,600 645,156 444,191 161,702 0 39,264 0 645,157 -1
23 [CS.10.1] M20 VDF 28,214,505 16,578,330 11,529,601 368,148 0 1,576,986 3,103,596 16,578,330 +0
24 [CS.10.2] Hardner on VDF 4,155,227 2,436,707 2,180,212 0 0 0 256,393 2,436,605 +103
25 [CS.11.A] White Wash 8,261,133 4,859,490 0 4,859,490 0 0 0 4,859,490 +0
26 [CS.12.A] Plastering 15,249,818 8,968,355 5,730,316 0 0 438,072 2,800,078 8,968,466 -112
27 [CS.13.1.A] M20 RCC 102,245 69,529 55,640 241 0 7,993 5,655 69,529 +0
28 [CS.13.1.B] M30 RCC 539,616 366,927 296,030 1,295 0 40,763 28,841 366,927 +0
29 [CS.13.1.C] M45 RCC 15,186,394 10,327,144 8,562,243 33,286 0 1,014,109 717,506 10,327,144 +0
30 [CS.13.1.D] M50 RCC 23,307,960 15,848,655 13,230,825 51,315 0 1,503,063 1,063,453 15,848,655 +0
31 [CS.13.1.E] M60 RCC 29,950,044 20,365,246 17,465,223 59,976 0 1,663,254 1,176,792 20,365,246 +0
32 [CS.13.1.F] M65 RCC 53,704,513 36,518,273 31,495,528 103,876 0 2,880,702 2,038,166 36,518,273 +0
33 [CS.13.2.A] M20 RCC 71,950 48,810 38,520 167 0 5,533 4,590 48,810 +0
34 [CS.13.2.B] M45 RCC 25,615,741 17,418,044 14,270,370 55,476 0 1,690,177 1,402,021 17,418,044 +0
35 [CS.13.2.C] M55 RCC 28,559,535 19,419,645 16,318,189 58,515 0 1,663,254 1,379,688 19,419,645 +0
36 [CS.13.2.D] M60 RCC 20,165,157 13,712,145 11,643,525 39,984 0 1,108,840 919,795 13,712,145 +0
37 [CS.13.3.A] M20 RCC 72,774 49,485 38,520 167 0 5,533 5,265 49,485 +0
38 [CS.13.3.B] M45 RCC 26,127,156 17,766,356 14,385,455 55,923 0 1,703,808 1,621,170 17,766,356 +0
39 [CS.13.3.C] M50 RCC 27,255,595 18,533,291 15,230,670 56,784 0 1,663,254 1,582,583 18,533,291 +0
40 [CS.13.3.D] M55 RCC 19,238,148 13,081,742 10,878,833 39,010 0 1,108,840 1,055,059 13,081,742 +0
41 [CS.13.4.A] M20 RCC 73,764 50,160 38,520 167 0 5,533 5,940 50,160 +0
42 [CS.13.4.B] M45 RCC 26,220,534 17,830,403 14,270,370 55,476 0 1,690,177 1,814,380 17,830,403 +0
43 [CS.13.4.C] M45 RCC 27,085,163 18,417,478 14,914,154 54,592 0 1,663,254 1,785,478 18,417,478 +0
44 [CS.13.4.D] M50 RCC 18,315,686 12,454,684 10,124,429 37,746 0 1,105,631 1,186,878 12,454,684 +0
45 [CS.13.5.A] M20 RCC 74,754 50,835 38,520 167 0 5,533 6,615 50,835 +0
46 [CS.13.5.B] M45 RCC 26,739,598 18,182,040 14,385,455 55,923 0 1,703,808 2,036,854 18,182,040 +0
47 [CS.13.5.C] M45 RCC 45,585,237 30,998,141 24,828,237 90,882 0 2,768,891 3,310,131 30,998,141 +0
48 [CS.13.6.A] M20 RCC 126,915 86,300 64,200 278 0 9,222 12,600 86,300 +0
49 [CS.13.6.B] M35 RCC 34,985,509 23,789,135 18,051,138 77,045 0 2,392,369 3,268,583 23,789,135 0
50 [CS.13.6.C] M35 RCC 19,762,940 13,438,676 10,426,809 40,441 0 1,255,751 1,715,675 13,438,676 +0
51 [CS.13.6.D] M40 RCC 47,517,386 32,313,353 25,258,411 95,389 0 2,941,170 4,018,384 32,313,353 +0
52 [CS.13.7.A] All Grade RCC 24,737,558 14,598,908 0 0 0 0 14,598,458 14,598,458 +450
53 [CS.14.1.A] Formwork - Conv. 68,660,244 40,372,444 0 0 18,541,569 1,788,910 20,041,964 40,372,444 +0
54 [CS.14.2.1] Formwork - Allum. 29,962,122 17,618,223 0 0 9,079,431 1,340,867 7,197,730 17,618,028 +195
55 [CS.14.2.2] Formwork - Allum. 42,264,840 24,830,594 0 0 11,982,300 1,769,568 11,078,468 24,830,336 +257
56 [CS.14.2.3] Formwork - Allum. 45,587,205 26,804,950 0 0 11,982,300 1,769,568 13,052,825 26,804,692 +257
57 [CS.14.2.4] Formwork - Allum. 48,964,035 28,779,306 0 0 11,982,300 1,769,568 15,027,181 28,779,049 +257
58 [CS.14.2.5] Formwork - Allum. 52,340,865 30,753,662 0 0 11,982,300 1,769,568 17,001,537 30,753,405 +257
59 [CS.14.2.6] Formwork - Allum. 62,742,735 36,866,661 0 0 13,336,620 1,969,576 21,560,178 36,866,375 +286
60 [CS.15] Formwork - Allum. 10,246,328 6,015,837 0 0 0 0 6,016,147 6,016,147 -310
61 [CS.16.1.1] Reinf. Steel 159,114,577 124,522,060 109,237,936 576,199 0 2,296,067 12,411,858 124,522,059 +1
62 [CS.16.1.2] Reinf. Steel 109,583,160 85,758,896 74,153,625 391,139 0 1,558,631 9,655,500 85,758,896 +1
63 [CS.16.1.3] Reinf. Steel 104,934,933 82,121,054 70,004,036 369,251 0 1,471,411 10,276,355 82,121,054 +1
64 [CS.16.1.4] Reinf. Steel 98,063,360 76,743,268 64,507,625 340,259 0 1,355,883 10,539,500 76,743,267 +1
65 [CS.16.1.5] Reinf. Steel 92,926,000 72,722,680 60,287,500 318,000 0 1,267,180 10,850,000 72,722,680 +1
66 [CS.16.1.6] Reinf. Steel 134,040,155 104,898,501 85,549,771 451,251 0 1,798,166 17,099,312 104,898,500 +1
67 [CS.16.2.A] Reinf. Steel 15,784,774 12,361,570 5,705,340 0 0 0 6,656,230 12,361,570 +0
68 [CS.16.2.B] Reinf. Steel 7,321,776 5,736,976 2,852,640 0 0 0 2,884,336 5,736,976 +0
69 [CS.16.2.C] Reinf. Steel 10,523,072 8,240,960 4,754,400 0 0 0 3,486,478 8,240,878 +82
70 [CS.16.3.A] Reinf. Steel 16,450,397 12,837,015 5,990,607 3,993,738 0 0 2,852,670 12,837,015 +0
71 [CS.16.3.B] Reinf. Steel 7,989,300 6,249,408 2,947,164 1,704,384 0 0 1,597,860 6,249,408 +0
72 [CS.16.3.C] Reinf. Steel 4,817,792 3,771,824 1,965,152 855,792 0 0 950,880 3,771,824 +0
73 [CS.17.1.B] Struct. Steel 7,694,299 6,021,470 3,858,220 1,425,200 0 229,050 509,000 6,021,470 +0
74 [CS.17.2.B] Struct. Steel 5,113,290 4,001,600 2,509,200 984,000 0 180,400 328,000 4,001,600 +0
75 [CS.18.1.1] 100mm AAC Block 20,970,079 12,326,169 6,348,952 0 0 649,857 5,327,360 12,326,169 +0
76 [CS.18.1.2] 200mm AAC Block 8,869,171 5,214,195 3,114,138 0 0 324,850 1,775,208 5,214,195 +0
77 [CS.18.1.3] 250mm AAC Block 5,344,290 3,141,425 1,829,733 351,296 0 195,927 764,468 3,141,425 +0
78 [CS.18.2.A] 115mm Brick Work 801,000 470,853 253,846 38,282 0 20,319 158,405 470,851 +2
79 [CS.18.3.B] 230mm Brick Work 1,187,500 698,018 421,981 153,617 0 37,301 85,119 698,018 +0
80 [CS.19.A] White Wash 926,062 544,742 0 544,742 0 0 0 544,742 +0
81 [CS.20.A] Plastering 7,276,198 4,276,692 2,318,889 0 0 177,275 1,780,496 4,276,660 +33
82 [CS.21] Plastering 3,812,304 2,240,785 1,256,998 0 0 53,774 930,010 2,240,782 +3
83 [CS.23.1.A] Swellable Bar 2,666,062 1,568,272 0 1,568,272 0 0 0 1,568,272 +0
84 [CS.24] 3,439,139 2,021,438 0 2,021,438 0 0 0 2,021,438 +0
85 [CS.25] MS Rungs 171,870 101,100 85,935 0 0 0 15,165 101,100 +0
86 [CS.26.A] PUDDLE Flanges 117,342 68,966 0 68,965 0 0 0 68,965 +1
87 [CS.26.B] PUDDLE Flanges 14,940 8,781 0 8,781 0 0 0 8,781 +0
88 [CS.26.C] PUDDLE Flanges 27,864 16,378 0 16,378 0 0 0 16,378 +0
89 [CS.26.D] PUDDLE Flanges 92,184 54,190 0 54,190 0 0 0 54,190 0
90 [CS.26.E] PUDDLE Flanges 121,743 71,565 0 71,565 0 0 0 71,565 +0
91 [CS.26.F] PUDDLE Flanges 129,360 76,043 0 76,043 0 0 0 76,043 0
92 [CS.26.G] PUDDLE Flanges 806,566 474,122 0 474,124 0 0 0 474,124 -2
93 [CS.26.H] PUDDLE Flanges 281,400 165,416 0 165,416 0 0 0 165,416 +0
94 [CS.26.I] PUDDLE Flanges 99,648 58,572 0 58,572 0 0 0 58,572 +0
95 [CS.27.1.A] PUDDLE Flanges 709,512 416,999 0 416,999 0 0 0 416,999 +0
96 [CS.27.1.B] PUDDLE Flanges 612,066 359,729 0 359,729 0 0 0 359,729 +0
97 [CS.27.1.C] PUDDLE Flanges 228,272 134,187 0 134,187 0 0 0 134,187 +0
98 [CS.27.1.D] PUDDLE Flanges 358,581 210,781 0 210,781 0 0 0 210,781 +0
99 [CS.28.1.A] PUDDLE Flanges 241,536 141,957 0 141,957 0 0 0 141,957 +0
100 [CS.28.1.B] PUDDLE Flanges 529,740 311,419 0 311,418 0 0 0 311,418 +1
101 [CS.28.1.C] PUDDLE Flanges 148,335 87,189 0 87,187 0 0 0 87,187 +2
102 [CS.28.1.D] PUDDLE Flanges 101,175 59,469 0 59,469 0 0 0 59,469 +0
103 [CS.29.A] Cutout Closing 517,968 304,501 142,036 52,800 0 15,203 94,519 304,558 -56
104 [CS.29.B] Cutout Closing 982,256 577,331 127,050 408,772 0 17,854 23,654 577,331 +0
105 [CS.29.C] Cutout Closing 1,503,392 883,708 211,750 611,574 0 29,757 30,624 883,705 +3
106 [CS.30.1.A] Conduiting 21,045,490 12,379,700 0 12,379,700 0 0 0 12,379,700 +0
107 [CS.30.1.B] Conduiting 1,438,208 842,700 0 842,700 0 0 0 842,700 +0
108 [CS.30.1.C] Conduiting 275,481 161,712 0 161,712 0 0 0 161,712 +0
109 [CS.30.2.A] Conduiting 1,232,442 722,466 0 722,466 0 0 0 722,466 +0
110 [CS.30.2.B] Conduiting 43,731 25,628 0 25,425 0 0 0 25,425 +203
111 [CS.30.2.C] Conduiting 14,877 8,733 0 8,733 0 0 0 8,733 +0
112 [CS.30.2.D] Conduiting 6,727,900 3,965,920 0 3,965,920 0 0 0 3,965,920 +0
113 [CS.30.2.E] Conduiting 233,634 137,133 0 137,133 0 0 0 137,133 +0
114 [CS.30.2.F] Conduiting 77,526 45,552 0 46,165 0 0 0 46,165 -613
115 [CS.31.A] GI Box 1,477,810 869,300 0 869,267 0 0 0 869,267 +33
116 [CS.31.B] GI Box 1,966,852 1,153,740 0 1,153,634 0 0 0 1,153,634 +106
117 [CS.31.C] GI Box 816,816 480,480 0 480,476 0 0 0 480,476 +4
118 [CS.31.D] GI Box 1,738,547 1,020,855 0 1,020,829 0 0 0 1,020,829 +26
119 [CS.31.E] GI Box 327,624 192,720 0 192,717 0 0 0 192,717 +3
120 [CS.32.A] GI Box 710,600 418,000 0 417,984 0 0 0 417,984 +16
121 [WP.1.1.A] Water Proofing 3,374,970 2,306,191 0 2,306,191 0 0 0 2,306,191 +0
122 [WP.1.1.B] Water Proofing 2,592,933 1,771,866 0 1,771,866 0 0 0 1,771,866 +0
123 [WP.1.2] Water Proofing 2,304,523 1,573,650 0 1,573,650 0 0 0 1,573,650 +0
124 [WP.2] Water Proofing 1,151,436 786,500 0 786,500 0 0 0 786,500 +0
125 [WP.3.1] Water Proofing 31,278,716 21,372,892 0 21,372,892 0 0 0 21,372,892 +0
126 [WP.3.2] Water Proofing 2,418,444 1,652,427 0 1,652,427 0 0 0 1,652,427 +0
127 [WP.4] Water Proofing 1,588,162 1,076,720 0 1,076,720 0 0 0 1,076,720 +0
128 [WP.5] Water Proofing 6,891,008 4,710,650 0 4,710,650 0 0 0 4,710,650 +0
129 [WP.6] Water Proofing 7,834,833 5,354,100 0 5,354,100 0 0 0 5,354,100 +0
130 [WP.8.1] Water Proofing 10,114,552 6,912,583 0 6,912,583 0 0 0 6,912,583 +0
131 [WP.8.2] Water Proofing 1,583,265 1,081,937 0 1,081,937 0 0 0 1,081,937 +0
132 [WP.9.1.A] Water Proofing 965,800 660,000 0 660,000 0 0 0 660,000 +0
133 [WP.9.1.B] Water Proofing 529,540 361,900 0 361,900 0 0 0 361,900 +0
134 [WP.9.1.C] Water Proofing 411,600 281,250 0 281,250 0 0 0 281,250 +0
135 [WP.9.2.A] Water Proofing 1,901,862 1,299,600 0 1,299,600 0 0 0 1,299,600 +0
136 [WP.9.2.B] Water Proofing 990,432 676,818 0 676,818 0 0 0 676,818 +0
137 [WP.9.3.A] Water Proofing 1,106,280 756,000 0 756,000 0 0 0 756,000 +0
138 [WP.9.3.B] Water Proofing 585,360 400,000 0 400,000 0 0 0 400,000 +0
139 [WP.9.3.C] Water Proofing 585,360 400,000 0 400,000 0 0 0 400,000 +0
140 [WP.9.3.D] Water Proofing 1,223,228 835,948 0 835,948 0 0 0 835,948 +0
141 [LPS.A.2] LPS 14,480 9,900 0 9,900 0 0 0 9,900 +0
142 [LPS.A.3] LPS 1,494 1,020 0 1,020 0 0 0 1,020 +0
143 [LPS.A.4] LPS 74,564 50,960 0 50,960 0 0 0 50,960 +0
144 [LPS.A.5] LPS 1,320 900 0 900 0 0 0 900 +0
145 [LPS.B.6] LPS 39,200 26,800 0 26,800 0 0 0 26,800 +0
146 [LPS.B.8] LPS 16,080 11,000 0 11,000 0 0 0 11,000 +0
147 [LPS.B.9] LPS 4,680 3,200 0 3,200 0 0 0 3,200 +0
148 [LPS.B.10] LPS 1,160 800 0 800 0 0 0 800 +0
149 [LPS.B.11] LPS 12,444 8,540 0 8,540 0 0 0 8,540 +0
150 [LPS.B.12] LPS 94,350 64,750 0 64,750 0 0 0 64,750 +0
151 [LPS.B.13] LPS 122,100 83,250 0 83,250 0 0 0 83,250 +0
152 [LPS.B.14] LPS 11,220 7,650 0 7,650 0 0 0 7,650 +0
153 [LPS.B.15] LPS 12,320 8,400 0 8,400 0 0 0 8,400 +0
154 [LPS.B.16] LPS 29,120 19,880 0 19,880 0 0 0 19,880 +0
155 [LPS.C.18] LPS 696,960 475,200 0 475,200 0 0 0 475,200 +0
156 [LPS.C.19] LPS 2,547,072 1,742,400 0 1,742,400 0 0 0 1,742,400 +0
157 [LPS.D.20] LPS 300,492 206,220 0 206,220 0 0 0 206,220 +0
158 [LPS.D.21A] LPS 216,144 147,730 0 147,730 0 0 0 147,730 +0
159 [LPS.D.21B] LPS 13,568 9,280 0 9,280 0 0 0 9,280 +0
160 [LPS.D.22] LPS 388,872 265,140 0 265,140 0 0 0 265,140 +0
161 [LPS.E.23] LPS 18,492 12,650 0 12,650 0 0 0 12,650 +0
162 [LPS.E.24] LPS 5,382 3,680 0 3,680 0 0 0 3,680 +0
163 [LPS.E.27] LPS 19,521 13,365 0 13,365 0 0 0 13,365 +0
164 [LPS.E.28] LPS 300,486 205,250 0 205,250 0 0 0 205,250 +0
165 [LPS.E.29] LPS 99,958 68,310 0 68,310 0 0 0 68,310 +0
166 [LPS.E.30] LPS 74,060 50,600 0 50,600 0 0 0 50,600 +0
167 [LPS.E.31] LPS 28,290 19,320 0 19,320 0 0 0 19,320 +0
168 [LPS.E.32] LPS 37,030 25,300 0 25,300 0 0 0 25,300 +0
169 [CS.4.3.B] M25 RCC 0 0 0 0 0 0 0 0 +0
170 [CS.4.3.E] M40 RCC 0 0 0 0 0 0 0 0 +0
171 [CS.4.3.H] M55 RCC 0 0 0 0 0 0 0 0 +0
172 [CS.4.3.I] M60 RCC 0 0 0 0 0 0 0 0 +0
Project Totals: ₹2,822,512,839 ₹1,975,867,515 1,300,803,484 120,345,749 122,197,787 90,846,188 341,672,809 ₹1,975,866,017 +₹1,498