Pier Re-bars(www.theengineeringcommunity.org).xls

	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	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BG	BI	BJ	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1		Arrangment reinforcement bars of Pier
2					Fly.02(P1,P2,P3)
3
4																			8700																												1800
5										150							56		@	150		=	8400						150														102			12		@	133			102																									8500
6																																															=	1596
7																							B2	D	22				B1	D	32																							B1	D	32
8						400																																			100																				500
9																																		700																				B2	D	22
10							500																																			100
11						@																																			200	100	100											B5	D	18
12						2																												800						1500		1200	100																				102					B1	13		−	D	32		x	9500
13							=																																															B4	D	18
14																																									@																																						1686
15						7500																																			6	=												B6	D	18
16													3350					900			900				3350																6
17																	100						100																		100																																														#DIV/0!
18						=																																																B3	D	22										R	=	45
19					9500	150																	7500																																							48															225									#DIV/0!
20						150																																																															B1																		~
21						@																																																								77					B2
22						50																																															C2	D	18							57		45
23						50																																																																				B4-1		0		−	D	18		x	#DIV/0!				(Average)
24																																C1	D	25
25																																																																																			8710
26															2100					1800			2100																																																	3855											(	#DIV/0!			~	#DIV/0!			)			5485
27																																																																					(	#DIV/0!			~	#DIV/0!			)														(	#DIV/0!
28
29							600															150	2000
30																																																												1606					B2-1		#DIV/0!		−	D	22		x	5461							630									B2-2		#DIV/0!		−
31						@																																																											B2-3		#DIV/0!		−	D	22		x	#DIV/0!				(Average)												B2-4		#DIV/0!		−
32						2	=																														45																	C3	D	18					630
33						500																															45
34						500																																@
35																																								125,6637061					5655
36																			6000																					125,6637061			=		5655
37
38
39
40
41							2000																		125								44		@	250		=	5750											125																	C2	D
42			110				1690							200												0																						0										2270																			91,0		91,0
43																																																																																100
44																																																								270																								100
45																						250
46																	F1	D	22			250																																				x
47																					2000	200	1400																																		1730	18									C1	D	18
48							F2	D	22													200																																				18
49																						@																																				D
50																						7	=																																			−
51							F7	D	18													350																																				72
52																						350			125								23		@	250		=	5750											125			F6	D	18			72
53																										0																						0										F7
54								1730																																																		F7						2542					C2-1		2		−	D	25		x	2542
55																																				6000																																R=809
56										2000																					3000											3000																																					0
57								250		7	@	200		350											125					22		@	125					125			11		@	250						125																																		0
58										=	1400															0					=	2750										=	2750					0																																				0
59				125																		125									F3	D	22									F4	D	22								125
60				125	0																	125	0																													125	0
61																																																										6330
62				5750																		5750																														5750
63																																																																					4200										2430
64																								22
65				=																	6000	=		22																												=					5790	x			330
66				250																		125		D																											22	250						18																													F2-1		47		−	D	22
67				250																		125		F1																											22	250						18																	880
68				@																		@																													D	@						D				F4-1		47		−	D	22		x	4530								F4-2		47		−	D	22		x	2760
69				23																		46																													F2	23						−
70				23																		46																														23						16			1646
71					0																		0																														0					16											880
72																																																										F6
73				125																		125																														125						F6																																			2430
74				125											F5	D	18					125																														125				270
75																									270								F5	16		−	D	18		x	6330																								2430											4200											F1-1		26		−	D	22
76
77																																				5790																										F3-1		49		−	D	22		x	4076								F3-2		49		−	D	22		x	5846
78
79																												39125
80			1125																					Pile length L=					38000																															BAR MARK				DIAMETER				LENGTH				NO.			WEIGHT					TOTAL					REMARK							BAR MARK
81							0																15		@	2500		=	37500																							500				D	W	D	W	BAR MARK				DIAMETER				(m)				NO.			(kgf/one)					(kgf)					REMARK							BAR MARK
82																																																								32	779,7	22	319,600	B1				D		32		9 500				13			59,974					779,7												F1-1
83										P1	D	25										P4	D	22															P2	D	25															22	#DIV/0!	22	457,000	B2-1				D		22		5 461				#DIV/0!			16,296					#DIV/0!												F1-2
84																															P5	D	14																							22	#DIV/0!	22	635,300	B2-2				D		22		6 115				#DIV/0!			18,247					#DIV/0!												F2-1
85																																																								22	#DIV/0!	22	387,100	B2-3				D		22		#DIV/0!				#DIV/0!			#DIV/0!					#DIV/0!												F2-2
86																																																							1200	22	#DIV/0!	22	596,000	B2-4				D		22		#DIV/0!				#DIV/0!			#DIV/0!					#DIV/0!												F3-1
87																																																								22	195,5	22	854,800	B3				D		22		4 679				14			13,963					195,5												F3-2
88																																																								18	#DIV/0!	22	635,300	B4-1				D		18		#DIV/0!				0			#DIV/0!					#DIV/0!												F4-1
89																																																								18	545,1	22	387,100	B4-2				D		18		4 786				57			9,562					545,1												F4-2
90																																																								18	#DIV/0!	18	202,400	B5-1				D		18		#DIV/0!				0			#DIV/0!					#DIV/0!												F5
91																																		P3	D	18																				18	429,6	18	202,400	B5-2				D		18		3 772				57			7,536					429,6												F6
92					25		@	150																																																18	34,1	18	326,600	B6				D		18		2 136				8			4,268					34,1												F7
93	75					=	3750										27		@	300		=	8100															54		@	500		=	27000								200
94							150																																																		779,7		0,000					D		32														779,7					kgf
95																																										*Per 1nos												P6	L(mm)		0		0,000					D		28														0					kgf
96			Dia of Pile							mm		1200									BAR MARK				DIAMETER				LENGTH				NO.			WEIGHT					TOTAL					REMARK								1	1048,322946		0		0,000					D		25														0					kgf
97			1st Re-bars Dia							mm		25				0		D	W		BAR MARK				DIAMETER				(m)				NO.			(kgf/one)					(kgf)					REMARK								2	959		#DIV/0!		4272,200					D		22														#DIV/0!					kgf
98			No. of 1st Re-bars							nos		24						25	996,4	0	P1				D		25		10 775				24			41,516					996,4												0	3	748		0		0,000					D		20														0					kgf
99			L(1/2Mmax)							m		9,5						25	2899	0	P2				D		25		31 350				24			120,792					2899												0				#DIV/0!		731,400					D		18														#DIV/0!					kgf
100			2nd Re-bars Dia							mm		25				3		18	854,4	3895,4	P3				D		18		3 997				107			7,985					854,4												0				0		0,000					D		16														0					kgf