Status:
YourSpreadsheets™
86 MARGERY STREET, LONDON
2nd Floor, 52 Marcus Hill, London www.YourSpreadsheets.co.uk Tel: 020 7542 8734
Drawing No: Sheet No:
Job No:
22668
Revision:
Section: Bar Bending schedule
Prepared By:
DJ
Date:
Ground Floor
Checked By:
DJ
Last Revised:
beam A
103
beam A
104
beam A
105
beam A
106
slab AB
slab AB
107
108
fe500 fe500
102
OF SETS
NUMBER PER SET
TOTAL NUMBER
LENGTH
BAR SHAPE
[mm]
C 12
12
fe500
beam A
101
NUMBER
2
15
30
2600
40 2000
D
12
2
2
15
15
30
30
5750
3850
D 40
2500 S
1200 S
3000
40 C 2500
1100
fe500
beam A
AND SIZE
12
3
15
45
3750
fe500
NATION
TYPE
16
3
15
45
4375
fe500
MARK DESIG-
16
3
10
30
4150
fe500
DESCRIPTION
fe500
Level:
16
16
3
3
10
10
30
30
5625
5800
40 2400
S
2500 50
500 D
1090 310050 S
500
400 50 2450 D
450 50 1500
250
#VALUE! A C S
L
A #VALUE! E L
#VALUE!
L
A
E L
A #VALUE! C
F D #VALUE!C E S D #VALUE! A S
This schedule conforms to IS 2502: 1999 REMARKS:
input your remarks here
Spreadsheet provided by: www.YourSpreadsheets.co.uk
Total weight on this pa
Status:
C
Drawing No:
A1/503
Sheet No:
BBS-1
Revision: Date:
4/1/2019
Last Revised:
REV. WEIGHT [kg]
BAR SHAPE
F
600 C
400
40 2000
69.25
S F
D 40
L
153.15
3000 C
D L
40 C 2500
F
40 D 2400
1500
F L300
1090 310050 S
F C600 D
50
2375 F S
2450 D
149.82
S F 400
500 D
450 50 1500
102.54
310.73
196.50
A
266.34
A
274.63
350 1560 S 200 F
E D
L
F D S A C E L
E L E A #VALUE! D C S F F D #VALUE!C
L
E S E #VALUE!
L
C F
weight on this page [kg] =
1522.971
Status:
YourSpreadsheets™
86 MARGERY STREET, LONDON
2nd Floor, 52 Marcus Hill, London www.YourSpreadsheets.co.uk Tel: 020 7542 8734
Drawing No: Sheet No:
Job No:
22668
Revision:
Section: Bar Bending schedule
Prepared By:
DJ
Date:
Ground Floor
Checked By:
DJ
Last Revised:
slab AB
110
slab AB
111
slab AB
112
slab AB
113
OF SETS
NUMBER PER SET
TOTAL NUMBER
LENGTH
BAR SHAPE
[mm]
fe500
109
NUMBER
12
1
25
30
1250
fe500
slab AB
AND SIZE
12
1
25
30
2475
fe500
NATION
TYPE
12
1
25
30
2300
fe500
MARK DESIG-
12
1
25
45
3675
fe500
DESCRIPTION
C
40
A 1250
S
40 2400 E
A
400 40 L S300
40
1500 D
slab AB
slab AB
115
116
fe500
114
fe500
slab AB
C
2200 L 1300
16
1
25
45
3550
D 50 2300 1400
fe500
Level:
16
16
16
1
1
1
25
25
25
30
30
30
2200 50 S
4975
6225
7700
500
800 50 2950 D
650 50 1800
450
#VALUE! A C S
L
A #VALUE! E L
#VALUE!
L
A
E L
A #VALUE! C
F D #VALUE!C E S D #VALUE! A S
This schedule conforms to IS 2502: 1999 REMARKS:
input your remarks here
Spreadsheet provided by: www.YourSpreadsheets.co.uk
Total weight on this pa
Status:
C
Drawing No:
A1/503
Sheet No:
BBS-2
Revision: Date:
4/1/2019
Last Revised:
REV. WEIGHT [kg]
BAR SHAPE
E
FS D
A 1250
33.29
F 40 2400 E C
65.92
D
100 40
61.26 1600F F
40
C 146.82 S
2200 L 1300
C
S F 500
2300 D
252.14
F 2200 L 50 D 1450 S 50
2075 F S
2950 D
650 50 1800
235.57
A
294.75
A
364.60
450 1960 S 500 F
E D
L
F D S A C E L
E L E A #VALUE! D C S F F D #VALUE!C E S
L
E #VALUE!
L
C F
weight on this page [kg] =
1454.350
YourSpreadsheets™
86 MARGERY STREET, LONDON
2nd Floor, 52 Marcus Hill, London www.YourSpreadsheets.co.uk Tel: 020 7542 8734 Section: Summary of Bar weights Location: Ground Floor
Status:
C
Drawing No:
A1/503
Sheet No:
BBS-1
Job No:
22668
Revision:
Prepared By:
DJ
Date:
Checked By:
DJ
Last Revised:
4/1/2019
### ### ###
Summary of bar lengths and weights Total length [m]
Bar size
(of all bars in this size)
Weight [kg]
5
0.000
0.000
6
0.000
0.000
8
0.000
0.000
10
0.000
0.000
12
1485.375
1318.737
16
1740.375
2746.897
20
0.000
0.000
22
0.000
0.000
25
0.000
0.000
28
0.000
0.000
32
0.000
0.000
36
0.000
0.000
40
0.000
0.000
45
0.000
0.000
50
0.000
0.000
Total weight [kg]
PRESS BUTTON: ### 'RECALCULATE ### WEIGHTS' ### ### ### ### ### ### ### ### ### ###
4065.634
Additional information:
This schedule conforms to IS 2502: 1999 Status: P Preliminary T Tender
C Construction Spreadsheet provided by: www.YourSpreadsheets.co.uk
Version: 3.2. - FREE LITE VERSION For latest updates and news visit: www.YourSpreadsheets.co.uk
© 2010-2015 Damian Janicki Contact me at:
[email protected]
General information: Note: This spreadsheet contains macros. To change company logo: right click it and select 'change picture'.
The Author takes no liability for use of this spreadsheet and gives no guarantee that it is error free. In no event shall the Author be responsible for any special, incidental or consequential damages whatsoever arising from the use of this spreadsheet, even if the Author has been advised of the possibility of such damage. This spreadsheet is a lite version and is a freeware and can be distributed freely but only in its original form. Reverse-engineering, decompiling or disassembling of this spreadsheet is not allowed. By using this spreadsheet you understand and agree with the above terms and conditions. You also acknowledge that you do not become the owner of this spreadsheet. Damian Janicki
This is a Free Lite version. The full version of the spreadsheet allows to: - Input your company information and change logo - Change number of bars - Input bar mark designation
This spreadsheet is based on IS 2502: 1999. Changelog: 04.01.2015 - v.3.2. - added option to control offset on page, of bar shape diagrams. 19.10.2013 - v.3.1. - major upgrade: added optimization, sorting, tagging, exporting to fully editable spreadsheet, delivery note and a few performance improvements. 11.03.2012 - v.2.2. - major improvement of performance. Expanded range of bar shapes (by 18 new bar shapes). Changed how bar shape diagrams are displayed and copied. Improved recalculating bar weights in a summary sheet. 14.08.2011 - v.2.1. - assigned to a new domain: www.YourSpreadsheets.co.uk 17.03.2011 - v.1.4. - added button to print all sheets. Summary of bar weights now
automatically recalculates. 27.11.2010 - v.1.3. - cell protection revised to work on Excel 97 and older.
This spreadsheet is based on IS 2502: 1999. Changelog: 04.01.2015 - v.3.2. - added option to control offset on page, of bar shape diagrams. 19.10.2013 - v.3.1. - major upgrade: added optimization, sorting, tagging, exporting to fully editable spreadsheet, delivery note and a few performance improvements. 11.03.2012 - v.2.2. - major improvement of performance. Expanded range of bar shapes (by 18 new bar shapes). Changed how bar shape diagrams are displayed and copied. Improved recalculating bar weights in a summary sheet. 14.08.2011 - v.2.1. - assigned to a new domain: www.YourSpreadsheets.co.uk 17.03.2011 - v.1.4. - added button to print all sheets. Summary of bar weights now
automatically recalculates. 27.11.2010 - v.1.3. - cell protection revised to work on Excel 97 and older. 30.10.2010 - v.1.2. - 15% increase in performance. Summary of bar weights added. 10.10.2010 - v.1.1. - official release of the spreadsheets.
-2015 Damian Janicki