Bbs work sample.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1	Serial Nos.	Member Ref.	COVER	H	L	W	Bar dia	D	0.42*D	Spacing	no of mem	Nos. of Bars	SAME TYPE STIRRUP MEMBER	NO OF ST	Length of Segment in Meter								Total Length of Bar in Meter (Dia wise)
2															a	b	c	d	DEV LENGTH(40d)	Hook	(DEDUCTION) F	TOTAL CUUT LE	6	8	10	12	16	20	25	32
3															a	b	c	d	DEV LENGTH(40d)	Hook	(DEDUCTION) F	TOTAL CUUT LE	6	8	10	12	16	20	25	32
4	Foundation reinforcement calculationn
5	Pile main bar and rings
6	1	PC1			dia pile	rad					2
7		main bar	40	3658	230	115	12					6							480		-24	4.114				49.368
8		ring	40	3658	230	67	8			100			1	37.58						160	-48	0.53276		40.0422416
9		burst rein	40	3658	230	115	10					2							400		-20	4.038			16.152
10
11	2	PC2			dia pile	rad					2
12		main bar	40	3658	230	115	12					6							480		-24	4.114				49.368
13		ring	40	3658	230	67	8			100			1	37.58						160	-48	0.53276		40.0422416
14		burst rein	40	3658	230	115	10					2							400		-20	4.038			16.152
15
16	3	PC3			dia pile	rad					1
17		main bar	40	3658	230	115	12					6							480		-24	4.114				24.684
18		ring	40	3658	230	67	8			100			1	37.58						160	-48	0.53276		20.0211208
19		burst rein	40	3658	230	115	10					2							400		-20	4.038			8.076
20
21	4	PC1			dia pile	rad					5
22		main bar	40	3658	230	115	12					6							480		-24	4.114				123.42
23		ring	40	3658	230	67	8			100			1	37.58						160	-48	0.53276		100.105604
24		burst rein	40	3658	230	115	10					2							400		-20	4.038			40.38
25
26	5	PC5			dia pile	rad					2
27		main bar	40	3658	300	150	12					6							480		-24	4.114				49.368
28		ring	40	3658	300	102	8			100			1	37.58						160	-48	0.75256		56.5624096
29		burst rein	40	3658	300	150	10					2							400		-20	4.038			16.152
30
31																				Total Length of Bar in Meter (Dia wise)				256.7736176	96.912	296.208
32																						Total in kg		101.4414292	59.82222222	263.296	424.5596514
33
34	Pile cap
35	1	PC1									2
36		bottom	40	550	550	550	10			125		4.76								200	-60	0.69			6.5688
37		top	40	550	550	550	10			125		4.76								200	-60	0.69			6.5688
38		ring	40	550	550	550	8			100			1	5.7	462	462	462	462		160	-80	1.928		21.9792
39
40	2	PC2									2
41		bottom	40	500	500	500	10			125		4.36								200	-60	0.64			5.5808
42		top	40	500	500	500	10			125		4.36								200	-60	0.64			5.5808
43		ring	40	500	500	500	8			100			1	5.2	412	412	412	412		160	-80	1.728		17.9712
44
45	3	PC3									1
46		bottom	40	500	500	500	10			125		4.36								200	-60	0.64			2.7904
47		top	40	500	500	500	10			125		4.36								200	-60	0.64			2.7904
48		ring	40	500	500	500	8			100			1	5.2	412	412	412	412		160	-80	1.728		8.9856
49
50	4	PC4									5
51		bottom	40	550	550	550	10			125		4.76								200	-60	0.69			16.422
52		top	40	550	550	550	10			125		4.76								200	-60	0.69			16.422
53		ring	40	550	550	550	8			100			1	5.7	462	462	462	462		160	-80	1.928		54.948
54
55	5	PC5									2
56		bottom	40	550	550	550	10			125		4.76								200	-60	0.69			6.5688
57		top	40	550	550	550	10			125		4.76								200	-60	0.69			6.5688
58		ring	40	550	550	550	8			100			1	5.7	462	462	462	462		160	-80	1.928		21.9792
59
60																				Total Length of Bar in Meter (Dia wise)				125.8632	75.8616
61																						Total in kg		49.72373333	46.82814815	96.55188148
62
63	Plinth Beam
64	1	PB1		0.4	3.455	0.23					2
65		TOP 2 T-16	25	400	3455	230	16					2							640		-64	4.031					16.124
66		BOTTOM 2T-16	25	400	3455	230	16					2							640		-64	4.031					16.124
67		EXTRA BOTTOM 2T-12	25	400	3455	230	12					2								240	-48	3.647				14.588
68		TOP BOTTOM 2T-12	25	400	3455	230	12					2								240	-48	3.647				14.588
69		STIRUPS UPTO L/3	25	400	1151.666667	230	8			125				10.21333333	342	172	342	172		160	-80	1.108		22.63274667
70		STIRUPS AFTER L/3	25	400	2303.333333	230	8			150				16.35555556	342	172	342	172		160	-80	1.108		36.24391111
71
72	2	PB1		0.4	3.912	0.23					1
73		TOP 2 T-16	25	400	3912	230	16					2							640		-64	4.488					8.976
74		BOTTOM 2T-16	25	400	3912	230	16					2							640		-64	4.488					8.976
75		EXTRA BOTTOM 2T-12	25	400	3912	230	12					2								240	-48	4.104				8.208
76		TOP BOTTOM 2T-12	25	400	3912	230	12					2								240	-48	4.104				8.208
77		STIRUPS UPTO L/3	25	400	1304	230	8			125				11.432	342	172	342	172		160	-80	1.108		12.666656
78		STIRUPS AFTER L/3	25	400	2608	230	8			150				18.38666667	342	172	342	172		160	-80	1.108		20.37242667
79
80	3	PB2A		0.3	4.344	0.23					1
81		TOP 2 T-12	25	300	4344	230	12					2							480		-48	4.776				9.552
82		BOTTOM 2T-16	25	300	4344	230	16					2							640		-64	4.92					9.84
83		EXTRA BOTTOM 2T-12	25	300	4344	230	12					2								240	-48	4.536				9.072
84		TOP BOTTOM 2T-12	25	300	4344	230	12					2								240	-48	4.536				9.072
85		STIRUPS UPTO L/3	25	300	1448	230	8			125				12.584	242	172	242	172		160	-80	0.908		11.426272
86		STIRUPS AFTER L/3	25	300	2896	230	8			150				20.30666667	242	172	242	172		160	-80	0.908		18.43845333
87
88	4	PB2A		0.3	4.115	0.23					1
89		TOP 2 T-12	25	300	4115	230	12					2							480		-48	4.547				9.094
90		BOTTOM 2T-16	25	300	4115	230	16					2							640		-64	4.691					9.382
91		EXTRA BOTTOM 2T-12	25	300	4115	230	12					2								240	-48	4.307				8.614
92		TOP BOTTOM 2T-12	25	300	4115	230	12					2								240	-48	4.307				8.614
93		STIRUPS UPTO L/3	25	300	1371.666667	230	8			125				11.97333333	242	172	242	172		160	-80	0.908		10.87178667
94		STIRUPS AFTER L/3	25	300	2743.333333	230	8			150				19.28888889	242	172	242	172		160	-80	0.908		17.51431111
95
96	5	PB2A		0.3	2.286	0.23					1
97		TOP 2 T-12	25	300	2286	230	12					2							480		-48	2.718				5.436
98		BOTTOM 2T-16	25	300	2286	230	16					2							640		-64	2.862					5.724
99		EXTRA BOTTOM 2T-12	25	300	2286	230	12					2								240	-48	2.478				4.956
100		TOP BOTTOM 2T-12	25	300	2286	230	12					2								240	-48	2.478				4.956