Steel reconciliation format in excel.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	COMPANY NAME ONSITE XL
2	R.A BILL-07
3	Theoretical quantity as design / BBS
4	Reinforcement Summery
5	S.No.	Description	8mm	10mm	12mm	16mm	20mm	25mm	32mm	Total	Remarks
6
7	1	#ERROR!
8	1	Foundation Column	1827	405	7333	246	1531	5505		16847
9	2	Column Footing	0	2290	2849	905	0	0		6045
10	3	Retaining wall Footing	380	1648	1378	0	199	1420		5026
11	4	Foundation Retaining wall	4164	2774	585	355	3013	11488		22380
12	5	Foundation to UB Lift wall	1335	5464	901	719	790	0		9210
13	6	UB beam	3644	3363	0	2013	14931	6678		30630
14	7	UB Top Slab	3182	572	0	0	0	0		3754
15	8	UB Bottom Slab	3785	436	0	0	0	0		4221
16	9	UB Column	2348	350	0	366	3519	4034		10617
17	10	UB Retaining wall	1054	2994	600	0	0	0		4648
18	11	UB Staircase ST-03	83	202	247	6	61	0		599
19	12	UB Entrance staircase	330	506	994	11	98	26		1965
20	13	GF beam	2284	4577	0	1650	15264	7333		31108
21	14	GF Top Slab	4174	1279	415	0	0	0		5867
22	15	GF Bottom Slab	3167	627	631	0	0	0		4425
23	16	GF Column	3239	567	0	984	4611	6250		15651
24	17	GF Staircase ST-03	83	200	260	6	60	0		609
25	18	1st beam	2854	4609	0	2074	17391	7118		34046
26	19	1st Top Slab	4023	1452	1047	0	0	0		6521
27	20	1st Bottom Slab	2772	714	736	0	0	0		4222
28	21	1st Column	3243	567	159	1009	6292	2719		13988
29	22	1st Staircase ST-03	83	200	260	6	60	0		609
30	23	2nd Floor beam	2596	4978	0	1422	17915	8601		35513
31	24	2nd Floor Top Slab	4387	1447	744	0	0	0		6578
32	25	2nd Floor Bottom Slab	3432	718	610	0	0	0		4760
33	26	2nd Floor Column	3243	567	119	1873	5947	1102		12852
34
35
36		G.Total in Kg	61714.5	43502.3	19869.2	13646.3	91681.9	62276.5	0.000	292690.66	292.7
37		Less Previous Qty	36269.7	22291.1	5354.7	6687.4	46278.3	30563.8		147445.05	147.4
38		This Bill Qty	22848.4	16233.2	14514.6	5536.6	27488.7	23111.3	0.0	109732.78
39		This Bill Qty in MT	22.848	16.233	14.515	5.537	27.489	23.111	0.000	109.733
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100