Beam Design Spreadsheet_BS_Code_Great_Mahfuz.xlsx

	B	C	D	E	F	G	H
1
2
3
4
5						Caculation Sheet
6
7	Project Title:				Designed by:	Rob Lane
8					Checked by:	Maire Greene	Sheet: of:
9	Project No:				Approved by:
10	Element:	Post Tensioned Concrete Beam			File Ref:		Rev:
11	Package:				Package No:		Date:
12	Item						Output
13
14		1.0	Geometry
15
16	1.1
17	Spans	Span 1	20	m
18		Span 2	10	m
19
20		Overal Length	30	m
21
22
23	1.2	Overall
24	Cross	Width	1	m
25	Section	Depth	0.8	m
26
27		Void width	0.6	m
28		Void height	0.4	m
29		Depth to void	0.2	m	from top to be sitting in the middle
30
31		Area	0.56	m2
32
33		I/T Beam Analogy
34		Top Flange
35		Width	1	m
36		Depth	0.2	m
37		A	0.2	m2
38
39		Bottom Flange
40		Width	1	m
41		Depth	0.2	m
42		A	0.2	m2
43
44		Web
45		Thickness	0.4	m
46		Length	0.4	m
47
48		Area	560000	mm2
49
50
51
52
53
54
55		2.0	Material Properties
56
57	2.1
58	Concrete	Unit Weight	24	kN/m3
59
60		Characteristic Strength (fck)	45	N/mm2
61
62		fcm	53	N/mm2
63
64		Assuming transfer at day 5
65		t =	5
66
67		Time factor (β)	0.711
68
69		fcm (5)	37.663	N/mm2
70
71		fck (5)	29.663	N/mm2
72
73		fctm	3.795	N/mm2
74
75		fctm (5)	2.697	N/mm2
76
77		fct	17.798	fcw	27
78		ftt	-2.697	ftw	0
79
80		ymc	1.5
81
82
83
84
85	2.2
86	Steel	Tendon Type	EN10138 7 wire steel strand, Y1770S7
87
88		fpk	1770	N/mm2
89
90		fp0.1k	1520	N/mm2
91
92		Area	140	mm2	each
93
94		Diameter	15.2	mm
95
96		Weight		kN/m
97
98		Ep	195	kN/mm2
99
100		yms	1.15