INTRODUCTION TO MADEBOQ 1 MADEBOQ means Materials Analysis Derived from Bills Of Quantities MADEBOQ I is a programme that can calculate the quantities of materials that are required for all items of work in an elemental bills of quantities. MADEBOQ I presents a format that is similar to a page of a typical bills of quantities; a columned page showing columns for serialization,description,quantity and unit. All you have to do is to input the quantities of measured work of your elemental bills of quantities into the corresponding sections of MADEBOQ I.For example,input your quantity for concrete in foundations against the corresponding item in MADEBOQ I section for substructure MADEBOQ 1 calls for bulk quantities for items bearing the same specification;rather than individual items' quantities as obtained in the bills of quantities.For example;you could have the following items with their quantities in your bill: S/No.
Description
Quantity
Unit
Plain in - situ concrete (1:3:6 - 40mm aggregate) in: A.
Foundations in trenches;thickness not exceeding 100mm
23
Cu.m
B.
Foundations in trenches;thickness 100 - 150mm
34
Cu.m
C.
Foundations in trenches;thickness 150 - 300mm
12
Cu.m
The corresponding item in MADEBOQ 1 is : S/No.
Description In - situ concrete (1:3:6 - 40mm aggregate) in: 1 Foundations
Unit
Cu.m.
Quantity
69
The MADEBOQ 1 quantity for foundations is obtained by adding up the individual items of the three bills of quantities items for foundations in trenches,that is 23 + 34 + 12 = 69 Cu.m. Now;carefully insert your quantities in the yellow cell that is adjacent to your corresponding item description in MADEBOQ 1. You do this by highlighting the appropriate yellow cell, typing your quantity figure into the cell and then pressing the ENTER key. DO NOT DELETE THE CURRENT VALUE THAT YOU MAY FIND IN THE YELLOW CELL. By the time you start typing your new values, EXCEL will delete the current values for you. The quantities of materials for each item will be calculated for you by MADEBOQ 1. The figures for the quantities of materials will be outputted in the green cells.MADEBOQ 1 is also able to calculate the total quantities of each material required in all sections of the bills of quantities.Consequently, MADEBOQ I will give section totals (by which you will be able to ascertain the total materials required in each element of the works) and grand totals (by which you will be able to ascertain the total quantity of materials required for the execution of the whole works). Scroll down to the end of each section of MADEBOQ 1 to obtain the section or elemental quantities of materials. When you scroll down to the end of each section of MADEBOQ 1,you will be able to obtain the total quantities of all the materials required for your works.
CAUTION!!! NEVER PRESS THE DELETE KEY ON ANY CELL WHATSOEVER. SOME OF THE CELLS ARE LOADED WITH MATHEMATICAL FUNCTIONS WHICH WOULD BE ERASED IF YOU PRESS THE DELETE KEY.THUS IF YOU WISH TO INPUT DATA IN A PARTICULAR CELL,JUST HIGHLIGHT THE CELL AND INPUT YOUR DATA,WITHOUT FIRST DELETING THE CONTENTS OF THE CELL.IN THIS CASE ONCE YOU INPUT YOUR DATA,EXCEL WILL AUTOMATICALLY REPLACE THE CURRENT DATA WITH THE NEW DATA YOU HAVE INPUTTED;AT THE SAME THE PREVAILING MATHEMATICAL FUNTIONS WILL BE PRESERVED TO ENABLE THE PROCESSING OF YOUR WORK. AS A RULE, AT THE END OF YOUR WORK, YOU COULD INPUT ZERO VALUES INTO THE INPUT CELLS (THE YELLOW CELLS) TO PREPARE THE PROGRAMME TO ACCEPT NEW VALUES. REMEMBER;NEVER PRESS THE DELETE KEY FOR WHATEVER REASON!!! YOU SHOULD REMEMBER THE FOLLOWING: Yellow cells are for inputting quantities for MADEBOQ 1 items Bright green cells are for outputting quantities of materials for MADEBOQ 1 items. Grey cells denote unit denomination for all quantities Golden cells are for headings Green cells are for boundaries Turquoise cells are for margins GOOD LUCK!
MADEBOQ 1 STARTS FROM HERE Insert Quantities from the bills of quantities here
Read your quantities here
BILLS OF QUANTITIES ELEMENT NO. 1 - SUBSTRUCTURE s/no Description Hardcore fiiling Hardcore to make up levels
Unit
MATERIALS' ANALYSIS Quantity
Material
Unit trip
Quantity
Cu.m.
0
Laterite
In-situ concrete(1:3:6-40mm aggregate) Foundation Cu.m.
0
Concrete (1:3:6-40mm agg.) materials Cement bag
0
Sand
trip
0
Aggregate 40mm
trip
0
Other
Cu.m.
0
0
In situ concrete(1:2:4-18mm aggregate) Foundation Cu.m
0
In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Bed
Cu.m
0
Sand
trip
0
Column
Cu.m
0
Aggregate 18mm
trip
0
Beam
Cu.m
Other
Cu.m
In situ concrete (1:10) Blinding bed
Cu.m
In situ concrete (1:10) Cement
bag
0
0 0
Sand Reinforcement Bars;round mild steel 6mm diameter
kg
8mm diameter
kg
10mm diameter
trip
0
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
0
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
0
10mm diameter
length
0
12mm diameter
kg
0
12mm diameter
length
0
16mm diameter
kg
0
16mm diameter
length
0
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
0
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Fabric reinforcement BRC
Sq.m.
0
BRC
roll
0
Formwork;sawn General surfaces
Sq.m.
0
Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
0
Columns and beams
Sq.m.
0 225mm block
No.
0
150mm block
No.
0
0
0
Bars;high yield steel
Sawn formwork to edges 500mm - 1.00m high Sawn formwork to edges
Lin.m
0
Concrete(1:3) materials for jointing
250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
Lin.m. 0
Brickwork and Blockwork Blockwork,sandcrete 450*230 filled solid with concrete 225mm
Sq.m
150mm
Sq.m
Sq.m
bag
0
Sand
trip
0
Concrete(1:6) materials for filling Cement bag
0
Sand
trip
0
Concrete(1:6) materials for rendering Cement bag
0
0
0 0 Rendering Cement and sand (1:6) Rendering
Cement
0
Sand SUBSTRUCTURE Laterite
trip SECTIONAL SUMMARY trip
0
Cement
bag
0
Sand
trip
0
Aggregate 40mm
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
0
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
BRC
roll
0
Plank
length
0
225mm block
No.
0
END OF SUBSTRUCTURE
150mm block
No.
0
ELEMENT NO. 2.FRAME
MATERIALS' ANALYSIS
In situ concrete(1:2:4-18mm aggregate) Columns Cu.m. Beams
Cu.m.
Reinforcement Bars;round mild steel 6mm diameter
kg
8mm diameter
kg
10mm diameter
0 0 0
In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sand
trip
0
Aggregate 18mm
trip
0
0
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
0
8mm diameter
length
0
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
0
Bars;high yield steel
0
16mm diameter
kg
0
16mm diameter
length
0
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
0
25mm diameter
length
0
32mm diameter Formwork;sawn General surfaces
kg
0
Sq.m.
0
32mm diameter length Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
Columns and beams
Sq.m.
0
Sawn formwork to edges 500mm - 1.00m high
Lin.m
Sawn formwork to edges 250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
0
FRAME SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
19mm ditto
length
0
25mm ditto
length
0
Lin.m. 0
32mm ditto
length
0
END OF FRAME
Plank
length
0
ELEMENT NO.3 UPPER FLOORS In situ concrete(1:2:4-18mm aggregate) Slabs Cu.m.
MATERIALS' ANALYSIS In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sand
trip
0
Aggregate 18mm
trip
0
Reinforcement Bars;round mild steel 6mm diameter
0
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
0
10mm diameter
length
0
12mm diameter
kg
0
12mm diameter
length
0
16mm diameter
kg
0
16mm diameter
length
0
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Formwork;sawn General surfaces
Sq.m.
Formwork Plank
length
0
0
Bars;high yield steel
0
(NOTE:1 length of plank = 3.66 metres) Columns and beams
Sq.m. UPPER FLOORS SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm
length
0
6mm high yield steel
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
END UPPER FLOORS
Plank
length
0
ELEMENT NO.4 ROOF
MATERIALS' ANALYSIS In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sawn formwork to edges 500mm - 1.00m high
Lin.m
Sawn formwork to edges 250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
0
Lin.m. 0
In situ concrete(1:2:4-18mm aggregate) Slabs Cu.m.
Upstand beams
Cu.m.
Roof beams
Cu.m.
Fascia
Cu.m.
Other
Cu.m.
0
Sand
trip
0
Aggregate 18mm
trip
0
0 Reinforcement Bars;round mild steel 6mm diameter
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
19mm diameter
kg
19mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Formwork;sawn General surfaces
Sq.m.
Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
0
To columns and beams
Sq.m.
Sawn formwork to edges 500mm - 1.00m high
Lin.m
0
Bars;high yield steel
0
Sawn formwork to edges 250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
Lin.m. 0
Roofing Corrugated sheet roofing Longspan aluminium
Sq.m
Longspan steel
Sq.m
Zinc
Sq.m
0
0 0
Roofing Corrugated sheet roofing Long span aluminium
Sq.m.
0
Longspan steel
Sq.m.
0
Zinc
sheet
0
length
0
length
0
Woodwork Sawn hardwood 150*50mm
Lin.m.
0
100*50mm
Lin.m.
0
Woodwork Sawn hardwood 150*50mm (NOTE: 1 length = 3.66m) 100*50mm
75*50mm
Lin.m.
0
75*50mm
length
0
Wrought hardwood 300*19mm fascia
Lin.m.
0
Wrought hardwood 300*19mm fascia (NOTE: 1 length = 3.66m)
length
0
length
0
Structural Steelwork Fabricated,hot rolled steel angles,BS4360,Grade 43C size: 50*50*6mm,3.58kg/m
tonne
Fabricated,hot rolled steel angles,BS4360,Grade 43C size: (NOTE: 1 length length==6.00m) 6.00m 50*50*6mm,3.58kg/m
51*51*6.2mm,4.77kg/m
tonne
51*51*6.2mm,4.77kg/m
length
0
57*57*6.2mm,5.35kg/m
tonne
57*57*6.2mm,5.35kg/m
length
0
75*50*6mm,5.65kg/m
tonne
75*50*6mm,5.65kg/m
length
0
76*64*9.4mm,9.68kg/m
tonne
76*64*9.4mm,9.68kg/m
length
0
76*76*6.2mm,5.96kg/m
tonne
76*76*6.2mm,5.96kg/m
length
0
89*64*9.4mm,10.57kg/m
tonne
89*64*9.4mm,10.57kg/m
length
0
57*57*6.2mm,5.35kg/m
tonne
57*57*6.2mm,5.35kg/m
length
0
Fittings and connections
Fittings and connections
16mm thick mild steel end plates
tonne
16mm thick mild steel end plates Sq.m.
0
10mm thick mild steel gusset plates
tonne
10mm thick mild steel gusset plates
Sq.m.
0
length
0
length
0
Unframed steelwork Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m
tonne
Ditto 102 * 51mm * 10.42 kg/m
tonne
Unframed steelwork Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m (NOTE: 1 length length==6.00m) 6.00m Ditto 102 * 51mm * 10.42 kg/m
Ditto 127 * 64mm * 14.90 kg/m
tonne
Ditto 127 * 64mm * 14.90 kg/m
length
0
Channel 229*76mm*26.06 kg/m
tonne
Channel 229*76mm*26.06 kg/m length
0
Finishes Beds and backing Cement and sand (1:4) 15mm thick screeded backing
Sq.m.
Finishes Beds and backing Cement and sand (1:4) Cement
bag
0
25mm thick ditto
Sq.m.
Sand
trip
0
ROOF SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
0
Corrugated sheet roofing Long span aluminium Sq.m. (NOTE:1 length = 12.00 metres) Longspan steel Sq.m. (NOTE:1 length = 12.00 metres) Zinc sheet
0 0 0
Woodwork Sawn hardwood 150*50mm (NOTE: 1 length = 3.66m) 100*50mm
length
0
length
0
75*50mm
length
0
Wrought hardwood 300*19mm fascia (NOTE: 1 length = 3.66m)
length
0
Fabricated,hot rolled steel angles,BS4360,Grade 43C size: (NOTE: 1 length length==6.00m) 6.00m 50*50*6mm,3.58kg/m
length
0
51*51*6.2mm,4.77kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
75*50*6mm,5.65kg/m
length
0
76*64*9.4mm,9.68kg/m
length
0
76*76*6.2mm,5.96kg/m
length
0
89*64*9.4mm,10.57kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
Fittings and connections 16mm thick mild steel end plates Sq.m.
0
10mm thick mild steel gusset plates
Sq.m.
0
length
0
length
0
length
0
Channel 229*76mm*26.06 kg/m length
0
MATERIALS' ANALYSIS In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sand
trip
0
Aggregate 18mm
trip
0
Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m (NOTE: 1 length length==6.00m) 6.00m Ditto 102 * 51mm * 10.42 kg/m Ditto 127 * 64mm * 14.90 kg/m
END OF ROOF ELEMENT NO.5 STAIRCASES In situ concrete(1:2:4-18mm aggregate) Staircases Cu.m.
Reinforcement Bars;round mild steel 6mm diameter
0
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
0
12mm diameter
length
0
16mm diameter
kg
0
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
0
16mm diameter
length
0
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
0
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Formwork,sawn Soffit of staircase & landings
Sq.m.
0
Formwork,sawn Plank
No.
0
Edges of landing slab; not exceeding 250mm
Lin.m.
0
Edges of staircase flights; maximum width 310mm
Lin.m.
0
Edges of risers not exceeding 250mm
Lin.m.
0 0
bag
0
Bars;high yield steel
0
Finishes Beds and backing Cement and sand (1:4) 25mm thick screeded backing Surfaces over 300mm wide
Sq.m.
0
Finishes Beds and backing Cement and sand (1:4) 25mm thick screeded backing Cement
Treads;300mm wide
Lin.m.
0
Sand
trip
0
Risers;150mm high
Lin.m.
0 0 In situ finishings Render,cement and sand (1:6); 15mm thick Cement
bag
0
Sand
trip
0
In situ finishings Render,cement and sand (1:6); 15mm thick Walls;internally
Sq.m.
Soffits of landings
Sq.m.
0
Sloping soffits of staircase
Sq.m.
0
String;not exceeding 300mm girth
Lin.m. 0 STAIRCASE SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
0
10mm diameter
length
0
12mm diameter
length
0
16mm diameter
length
0
20mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
0
10mm diameter
length
0
12mm diameter
length
0
16mm diameter
length
0
19mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
END OF STAIRCASE
Formwork,sawn Plank
No.
0
ELEMENT NO. 6 INTERNAL AND EXTERNAL WALLS
MATERIALS' ANALYSIS
Concretework In situ concrete Reinforced;(1:2:4 - 18mm agg.) Beams;isolated as lintels
Cu.m.
Walls
Cu.m.
0
Concretework In situ concrete Reinforced;(1:2:4 - 18mm agg.) Cement
bag
0
Sand
trip
0
Aggregate
trip
0
0
Reinforcement Bars;round mild steel 6mm diameter
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
0
8mm diameter
length
0
10mm diameter
kg
0
10mm diameter
length
0
12mm diameter
kg
0
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
19mm diameter
kg
19mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter Formwork;sawn Sides and soffits of lintels
kg
32mm diameter Formwork;sawn Plank
length
0
No.
0
Bars;high yield steel
Blockwork Blockwork;sandcrete 450*230mm in cement and sand (1:3)
Sq.m.
0
Blockwork Blockwork;sandcrete 450*230mm in cement and sand (1:3)
150mm thick
Sq.m.
230mm thick
Sq.m.
0 0
150mm thick
No.
0
230mm thick
No.
0
Concrete(1:3) materials for jointing Cement bag
0
Sand
0
trip
INTERNAL AND EXTERNAL WALLS SECTIONAL SUMMARY Cement bag
0
Sand
trip
0
Aggregate
trip
0
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
0
10mm diameter
length
0
12mm diameter
length
0
16mm diameter
length
0
20mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
0
10mm diameter
length
0
12mm diameter
length
0
16mm diameter
length
0
19mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
Formwork;sawn Plank
No.
0
150mm thick
No.
0
230mm thick
No.
0
MATERIALS' ANALYSIS Internal and External Work In situ finishings Render;cement and sand (1:6) 15mm thick Cement
bag
0
Sand
trip
0
Walls;cement and sand (1:3) Screeded backing;12mm thick Cement
bag
0
Sand Tiles;slab and block finishings
trip
0
150*150*6mm ceramic tiles
No.
0
Brick facing tiling;size 150 * 60 * 15mm
No.
0
WALL FINISHES SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
150*150*6mm ceramic tiles
No.
0
Carton of 150*150mm tiles No. (each carton contains 88 pieces)
0
Sandcrete block
ELEMENT NO. 7 WALL FINISHES Internal and External Work In situ finishings Render;cement and sand (1:6) 15mm thick Over 300mm wide;including dressing all reveals,junctions and quoins Sq.m. Curved areas
0
Sq.m. 0
Walls;cement and sand (1:3) Screeded backing;12mm thick To receive ceramic tiles
Sq.m.
Tiles;slab and block finishings Glazed ceramic wall tiling; 150 * 150 * 6mm
Sq.m.
Brick facing tiling;size 150 * 60 * 15mm
Sq.m.
END OF WALL FINISHES
0 0
0
Brick facing tiling;size 150 * 60 * 15mm
No.
0
ELEMENT NO. 8 FLOOR FINISHES Internal and External Work Polished in situ terrazo paving; 25mm thick in 1200 * 1200mm bays with an including black ebonite strips Paving internally
Sq. m.
Paving externally
Sq. m.
20 * 100mm high skirting
Lin.m.
Beds and backings Floors;screeded bed 25mm thick to receive quarry tiles 25mm thick to receive terrazo paving
Sq. m.
Sq. m.
32mm thick to receive granite tiling
Sq. m.
38mm thick to receive ceramic tiling
Sq. m.
48mm thick to receive PVC floor tiling
Sq. m.
PVC floor tiles;Dunlop 'Semtex' or' similar';250 * 250mm fixed with adhesive Flooring;2mm thick
0 0
bag
0
Marble
bag
0
Cement : marble ratio = 1:3 Cement
bag
0
Marble
bag
0
Beds and backings Cement
bag
0
Sand
trip
0
Tiles;slab and block finishings PVC floor tiles;Dunlop 'Semtex' or 'similar';300 * 300mm fixed with adhesive 300 * 300 *2mm PVC floor tiles
No.
0
Carton of 300*300mm PVC tiles No. (each carton contains 44 pieces)
0
0
Sq. m.
32mm thick to receive marble tiling
Tiles;slab and block finishings PVC floor tiles;Dunlop 'Semtex' or 'similar';300 * 300mm fixed with adhesive Flooring;2mm thick
0
MATERIALS' ANALYSIS Internal and External Work Polished in situ terrazo paving; 25mm thick in 1200 * 1200mm bays with an including black ebonite strips Cement : marble ratio = 1:2.5 Cement
0 0
Sq. m.
Sq. m.
0 0
Approved ceramic floor tiles; in cement mortar (1:3);300 * 300 size Flooring;12mm thick
Sq. m.
0
Skirting 100mm high
Lin.m.
0 0
PVC floor tiles;Dunlop 'Semtex' or' similar';250 * 250mm fixed with adhesive 250 * 250mm PVC floor tiles
No.
0
Carton of 250*250mm PVC tiles (each carton contains128 pieces) No.
0
Can of approved adhesive
No.
0
Ebonite strip
Length
0
Approved ceramic floor tiles; in cement mortar (1:3);300 * 300 size Ceramic floor tiles 300*300*12mm mm No. Approved colour polished natural
0
marble in cement mortar (1:3); 400 * 400mm size 400 * 400 *19mm marble tiles
Approved colour polished natural marble in cement mortar (1:3); 400 * 400mm size Flooring;19mm thick
Sq. m.
Skirting 100mm high
Lin.m.
0
No.
0
Approved colour polished natural granite in cement mortar (1:3); 400 * 400mm size 400 * 400 *19mm granite tiles No.
0
FLOOR FINISHES SECTIONAL SUMMARY Cement
bag
0
Marble
bag
0
Sand
trip
0
300 * 300 *2mm PVC floor tiles
No.
0
Carton of 300*300mm PVC tiles No. (each carton contains 44 pieces)
0
250 * 250mm PVC floor tiles
No.
0
Carton of 250*250mm PVC tiles (each carton contains128 pieces) No.
0
Can of approved adhesive
No.
0
Ebonite strip
Length
0
0 Approved colour polished natural granite in cement mortar (1:3); 400 * 400mm size Flooring;19mm thick
Sq. m.
Skirting 100mm high
Lin.m.
0
0
Ceramic floor tiles 225 * 225 *12 mm No.
0
400 * 400 *19mm marble tiles
No.
0
END OF FLOOR FINISHES
400 * 400 *19mm granite tiles
No.
0
ELEMENT NO.9 CEILING FINISHES Internal and External Work In situ finishings Render;cement and sand (1:6) Soffits
MATERIALS' ANALYSIS Internal and External Work In situ finishings Render;cement and sand (1:6) Cement
bag
0
Sand
trip
0
Plain sheet finishing 6mm thick hardboard ceiling
Sq.m.
0
lining on hardwood noggins 600 * 600 * 12mm thick chip board ceiling boards fixed to hardwood noggins Suspended ceiling Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick;with and including all timber supports;paint finish
Sq.m.
Sq.m.
0 0
0 0
Sq.m.
Plain sheet finishing Hardboard ceiling sheets;1200 * 2400 * 6mm thick No.
0
Chipboard ceiling boards;600 * 600 * 12mm thick
No.
0
Suspended ceiling Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick No.
0
0 Hardwood 50 * 50mm noggins
Lin.m.
12 * 50mm battens
Lin.m.
0 0 0 0
Hardwood 50 * 50mm noggins (NOTE: 1 length = 3.66m) 12 * 50mm battens (NOTE: 1 length = 3.66m)
length
0
length
0
CEILING FINISHES SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Hardboard ceiling sheets;1200 * 2400 * 6mm thick No.
0
Chipboard ceiling boards;600 * 600 * 12mm thick
No.
0
Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick No.
0
END OF CEILING FINISHES
Hardwood 50 * 50mm noggins (NOTE: 1 length = 3.66m) 12 * 50mm battens (NOTE: 1 length = 3.66m)
ELEMENT NO.10 PAINTING Internal and External Work
MATERIALS' ANALYSIS Emulsion paint
gallon
Prepare prime and apply three full finishing coats of emulsion paint;
Gloss paint
gallon
Whitewash primer
drum
General surfaces;over 300mm girth Walls Walls
Primer (gloss)
gallon
Texcote PAINTING
drum
Sq.m.
0
length
0
length
0
Staircases Walls
Sq.m.
Soffits of landings
Sq.m.
Sloping soffits of staircase
Lin.m.
Ceilings Soffits Suspended slab
Sq.m.
0
0
0
0
Gloss paint
gallon
0
Whitewash primer (25 kg drum) Primer (gloss)
drum
0
gallon
0
Texcote (30 kg drum)
drum
0
0 0
Painting wood & metal;prime and apply two full coats of gloss paint General surfaces;over 300mm girth Sq.m.
0
Ditto;150 - 300mm
Lin.m.
0
Ditto;not exceeding 150mm
Lin.m.
0 0
0
Apply two full coats of texcote paint General surfaces;over 300mm girth
Sq.m.
Ditto;150 - 300mm
Lin.m.
Ditto;not exceeding 150mm
Lin.m.
0
trip
0
END OF PAINTING Laterite
drum
0
Sq.m.
String;not exceeding 300mm girth
SECTIONAL SUMMARY Emulsion paint
0
0 0
GRAND SUMMARY OF ALL MATERIALS REQUIRED FOR THE PROJECT S/No.
Cement
bag
0
Sand
trip
0
Aggregate 40mm
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
BRC
roll
0
Plank
length
0
225mm block
No.
0
150mm block
No.
0
Sq.m.
0
Sq.m.
0
length
0
Corrugated sheet roofing Long span aluminium (NOTE:1 length = 12.00 metres) Longspan steel (NOTE:1 length = 12.00 metres) Zinc
Woodwork Sawn hardwood 150*50mm (NOTE: 1 length = 3.66m)
100*50mm
length
0
75*50mm
length
0
Wrought hardwood 300*19mm fascia (NOTE: 1 length = 3.66m)
length
0
Fabricated,hot rolled steel angles,BS4360,Grade 43C size: (NOTE: 1 length length==6.00m) 6.00m 50*50*6mm,3.58kg/m
length
0
51*51*6.2mm,4.77kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
75*50*6mm,5.65kg/m
length
0
76*64*9.4mm,9.68kg/m
length
0
76*76*6.2mm,5.96kg/m
length
0
89*64*9.4mm,10.57kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
Fittings and connections 16mm thick mild steel end plates
Sq.m.
0
10mm thick mild steel gusset plates
Sq.m.
0
length
0
length
0
Ditto 127 * 64mm * 14.90 kg/m
length
0
Channel 229*76mm*26.06 kg/m
length
0
150*150*6mm ceramic tiles
No.
0
Carton of 150*150mm tiles (each carton contains 88 pieces)
No.
0
Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m (NOTE: 1 length length==6.00m) 6.00m Ditto 102 * 51mm * 10.42 kg/m
Brick facing tiling;size 150 * 60 * 15mm
No.
0
300 * 300 *2mm PVC floor tiles
No.
0
Carton of 300*300mm PVC tiles (each carton contains 44 pieces)
No.
0
250 * 250mm PVC floor tiles
No.
0
Carton of 250*250mm PVC tiles (each carton contains128 pieces) No.
0
Can of approved adhesive
No.
0
Ebonite strip
Length
0
Ceramic floor tiles 225 * 225 *12 mm
No.
0
400 * 400 *19mm marble tiles
No.
0
400 * 400 *19mm granite tiles
No.
0
Hardboard ceiling sheets;1200 * 2400 * 6mm thick
No.
0
Chipboard ceiling boards;600 * 600 * 12mm thick
No.
0
Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick
No.
0
length
0
length
0
Emulsion paint
gallon
0
Gloss paint
gallon
0
Whitewash primer
drum
0
Primer (gloss)
gallon
0
Hardwood 50 * 50mm noggins (NOTE: 1 length = 3.66m) 12 * 50mm battens (NOTE: 1 length = 3.66m)
Texcote
drum
0
END OF MADEBOQ 1
p0
THOUT
F YOUR CELLS
INTRODUCTION TO MADEBOQ 1 MADEBOQ means Materials Analysis Derived from Bills Of Quantities MADEBOQ I is a programme that can calculate the quantities of materials that are required for all items of work in an elemental bills of quantities. MADEBOQ I presents a format that is similar to a page of a typical bills of quantities; a columned page showing columns for serialization,description,quantity and unit. All you have to do is to input the quantities of measured work of your elemental bills of quantities into the corresponding sections of MADEBOQ I.For example,input your quantity for concrete in foundations against the corresponding item in MADEBOQ I section for substructure MADEBOQ 1 calls for bulk quantities for items bearing the same specification;rather than individual items' quantities as obtained in the bills of quantities.For example;you could have the following items with their quantities in your bill: S/No.
Description
Quantity
Unit
Plain in - situ concrete (1:3:6 - 40mm aggregate) in: A.
Foundations in trenches;thickness not exceeding 100mm
23
Cu.m
B.
Foundations in trenches;thickness 100 - 150mm
34
Cu.m
C.
Foundations in trenches;thickness 150 - 300mm
12
Cu.m
The corresponding item in MADEBOQ 1 is : S/No.
Description In - situ concrete (1:3:6 - 40mm aggregate) in: 1 Foundations
Unit
Cu.m.
Quantity
69
The MADEBOQ 1 quantity for foundations is obtained by adding up the individual items of the three bills of quantities items for foundations in trenches,that is 23 + 34 + 12 = 69 Cu.m. Now;carefully insert your quantities in the yellow cell that is adjacent to your corresponding item description in MADEBOQ 1. You do this by highlighting the appropriate yellow cell, typing your quantity figure into the cell and then pressing the ENTER key. DO NOT DELETE THE CURRENT VALUE THAT YOU MAY FIND IN THE YELLOW CELL. By the time you start typing your new values, EXCEL will delete the current values for you. The quantities of materials for each item will be calculated for you by MADEBOQ 1. The figures for the quantities of materials will be outputted in the green cells.MADEBOQ 1 is also able to calculate the total quantities of each material required in all sections of the bills of quantities.Consequently, MADEBOQ I will give section totals (by which you will be able to ascertain the total materials required in each element of the works) and grand totals (by which you will be able to ascertain the total quantity of materials required for the execution of the whole works). Scroll down to the end of each section of MADEBOQ 1 to obtain the section or elemental quantities of materials. When you scroll down to the end of each section of MADEBOQ 1,you will be able to obtain the total quantities of all the materials required for your works.
CAUTION!!! NEVER PRESS THE DELETE KEY ON ANY CELL WHATSOEVER. SOME OF THE CELLS ARE LOADED WITH MATHEMATICAL FUNCTIONS WHICH WOULD BE ERASED IF YOU PRESS THE DELETE KEY.THUS IF YOU WISH TO INPUT DATA IN A PARTICULAR CELL,JUST HIGHLIGHT THE CELL AND INPUT YOUR DATA,WITHOUT FIRST DELETING THE CONTENTS OF THE CELL.IN THIS CASE ONCE YOU INPUT YOUR DATA,EXCEL WILL AUTOMATICALLY REPLACE THE CURRENT DATA WITH THE NEW DATA YOU HAVE INPUTTED;AT THE SAME THE PREVAILING MATHEMATICAL FUNTIONS WILL BE PRESERVED TO ENABLE THE PROCESSING OF YOUR WORK. AS A RULE, AT THE END OF YOUR WORK, YOU COULD INPUT ZERO VALUES INTO THE INPUT CELLS (THE YELLOW CELLS) TO PREPARE THE PROGRAMME TO ACCEPT NEW VALUES. REMEMBER;NEVER PRESS THE DELETE KEY FOR WHATEVER REASON!!! YOU SHOULD REMEMBER THE FOLLOWING: Yellow cells are for inputting quantities for MADEBOQ 1 items Bright green cells are for outputting quantities of materials for MADEBOQ 1 items. Grey cells denote unit denomination for all quantities Golden cells are for headings Green cells are for boundaries Turquoise cells are for margins GOOD LUCK!
MADEBOQ 1 STARTS FROM HERE Insert Quantities from the bills of quantitieshere
Read your quantities here
BILLS OF QUANTITIES ELEMENT NO. 1 - SUBSTRUCTURE s/no Description Hardcore fiiling Hardcore to make up levels
Unit
MATERIALS' ANALYSIS Quantity
Material
Unit trip
Quantity
Cu.m.
15
Laterite
In-situ concrete(1:3:6-40mm aggregate) Foundation Cu.m.
0 14 0 0 14
Concrete (1:3:6-40mm agg.) materials Cement bag
56
Sand
trip
6.3
Aggregate 40mm
trip
12.6
Other
Cu.m.
4.17
In situ concrete(1:2:4-18mm aggregate) Foundation Cu.m
0
In situ concrete(1:2:4-18mm aggregate) Cement bag
Bed
Cu.m
0
Sand
trip
0.43
Column
Cu.m
1
Aggregate 18mm
trip
0.85
Beam
Cu.m
Other
Cu.m
0 1
In situ concrete (1:10) Blinding bed
Cu.m
1
In situ concrete (1:10) Cement
bag
4.29
6
Sand Reinforcement Bars;round mild steel 6mm diameter
trip
0.4
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0.83
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
0
10mm diameter
length
0
12mm diameter
kg
50
12mm diameter
length
5.12
16mm diameter
kg
100
16mm diameter
length
8.33
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
0
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Fabric reinforcement BRC
Sq.m.
0
BRC
roll
0
Formwork;sawn General surfaces
Sq.m.
0
Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
Columns and beams
Sq.m.
0
10
Bars;high yield steel
Sawn formwork to edges 500mm - 1.00m high Sawn formwork to edges
Lin.m
0
10.38
225mm block
No.
800
150mm block
No.
0
Concrete(1:3) materials for jointing
250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
Lin.m.
76
38 Brickwork and Blockwork Blockwork,sandcrete 450*230 filled solid with concrete 225mm
Sq.m
80
150mm
Sq.m
0 1.84 0.8
Rendering Cement and sand (1:6) Rendering
Sq.m
0
Cement
bag
15.01
Sand
trip
0.53
Concrete(1:6) materials for filling Cement bag
4.48
Sand
trip
0.23
Concrete(1:6) materials for rendering Cement bag
0
Sand SUBSTRUCTURE Laterite
trip SECTIONAL SUMMARY trip
0 4.17
Cement
bag
85.78
Sand
trip
7.89
Aggregate 40mm
trip
12.6
Aggregate 18mm
trip
0.85
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0.83
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
5.12
16mm ditto
length
8.33
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
BRC
roll
0
Plank
length
225mm block
No.
800
END OF SUBSTRUCTURE
150mm block
No.
0
ELEMENT NO. 2.FRAME
MATERIALS' ANALYSIS
In situ concrete(1:2:4-18mm aggregate) Columns Cu.m. Beams
Cu.m.
Reinforcement Bars;round mild steel 6mm diameter
kg
8mm diameter
kg
10mm diameter
kg
12mm diameter
kg
16mm diameter
0 0 0
10.38
In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sand
trip
0
Aggregate 18mm
trip
0
0
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
0
8mm diameter
length
0
10mm diameter
length
0
12mm diameter
length
0
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
0
Bars;high yield steel
0
16mm diameter
kg
0
16mm diameter
length
0
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
0
25mm diameter
length
0
32mm diameter Formwork;sawn General surfaces
kg
0
Sq.m.
0
32mm diameter length Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
Columns and beams
Sq.m.
0
Sawn formwork to edges 500mm - 1.00m high
Lin.m
Sawn formwork to edges 250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
0
FRAME SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
19mm ditto
length
0
25mm ditto
length
0
Lin.m. 0
32mm ditto
length
0
END OF FRAME
Plank
length
0
ELEMENT NO.3 UPPER FLOORS In situ concrete(1:2:4-18mm aggregate) Slabs Cu.m.
MATERIALS' ANALYSIS In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sand
trip
0
Aggregate 18mm
trip
0
Reinforcement Bars;round mild steel 6mm diameter
0
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
0
10mm diameter
length
0
12mm diameter
kg
0
12mm diameter
length
0
16mm diameter
kg
0
16mm diameter
length
0
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Formwork;sawn General surfaces
Sq.m.
Formwork Plank
length
0
Bars;high yield steel
0
(NOTE:1 length of plank = 3.66 metres) Columns and beams
Sq.m. UPPER FLOORS SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm
length
0
6mm high yield steel
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
END UPPER FLOORS
Plank
length
0
ELEMENT NO.4 ROOF
MATERIALS' ANALYSIS In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sawn formwork to edges 500mm - 1.00m high
Lin.m
Sawn formwork to edges 250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
Lin.m. 0
In situ concrete(1:2:4-18mm aggregate) Slabs Cu.m.
Upstand beams
Cu.m.
Sand
trip
0
Roof beams
Cu.m.
Aggregate 18mm
trip
0
Fascia
Cu.m.
Other
Cu.m. 0
Reinforcement Bars;round mild steel 6mm diameter
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
19mm diameter
kg
19mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Formwork;sawn General surfaces
Sq.m.
Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
0
To columns and beams
Sq.m.
Sawn formwork to edges 500mm - 1.00m high
Lin.m
Bars;high yield steel
Sawn formwork to edges 250 - 500mm high
Lin.m.
Sawn formwork to edges not exceeding 250mm high
Lin.m. 0
Roofing Corrugated sheet roofing Longspan aluminium
Sq.m
Longspan steel
Sq.m
Zinc
Sq.m
0
0 0
Roofing Corrugated sheet roofing Long span aluminium
Sq.m.
0
Longspan steel
Sq.m.
0
Zinc
sheet
0
length
0
length
0
Woodwork Sawn hardwood 150*50mm
Lin.m.
0
100*50mm
Lin.m.
0
Woodwork Sawn hardwood 150*50mm (NOTE: 1 length = 3.66m) 100*50mm
75*50mm
Lin.m.
0
75*50mm
length
0
Wrought hardwood 300*19mm fascia
Lin.m.
0
Wrought hardwood 300*19mm fascia (NOTE: 1 length = 3.66m)
length
0
length
0
Structural Steelwork Fabricated,hot rolled steel angles,BS4360,Grade 43C size: 50*50*6mm,3.58kg/m
tonne
Fabricated,hot rolled steel angles,BS4360,Grade 43C size: (NOTE: 1 length length==6.00m) 6.00m 50*50*6mm,3.58kg/m
51*51*6.2mm,4.77kg/m
tonne
51*51*6.2mm,4.77kg/m
length
0
57*57*6.2mm,5.35kg/m
tonne
57*57*6.2mm,5.35kg/m
length
0
75*50*6mm,5.65kg/m
tonne
75*50*6mm,5.65kg/m
length
0
76*64*9.4mm,9.68kg/m
tonne
76*64*9.4mm,9.68kg/m
length
0
76*76*6.2mm,5.96kg/m
tonne
76*76*6.2mm,5.96kg/m
length
0
89*64*9.4mm,10.57kg/m
tonne
89*64*9.4mm,10.57kg/m
length
0
57*57*6.2mm,5.35kg/m
tonne
57*57*6.2mm,5.35kg/m
length
0
Fittings and connections
Fittings and connections
16mm thick mild steel end plates tonne
16mm thick mild steel end plates Sq.m.
0
10mm thick mild steel gusset plates
10mm thick mild steel gusset plates
Sq.m.
0
length
0
length
0
length
0
Channel 229*76mm*26.06 kg/m tonne
Channel 229*76mm*26.06 kg/m length
0
Finishes Beds and backing Cement and sand (1:4) 15mm thick screeded backing
Sq.m.
Finishes Beds and backing Cement and sand (1:4) Cement
bag
0
25mm thick ditto
Sq.m.
Sand
trip
0
ROOF SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
6mm mild steel bar
length
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
tonne
Unframed steelwork Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m
tonne
Ditto 102 * 51mm * 10.42 kg/m
tonne
Unframed steelwork Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m (NOTE: 1 length length==6.00m) 6.00m Ditto 102 * 51mm * 10.42 kg/m
Ditto 127 * 64mm * 14.90 kg/m
tonne
Ditto 127 * 64mm * 14.90 kg/m
0
8mm ditto
length
0
10mm ditto
length
0
12mm ditto
length
0
16mm ditto
length
0
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
Formwork Plank length (NOTE:1 length of plank = 3.66 metres)
0
Corrugated sheet roofing Long span aluminium Sq.m. (NOTE:1 length = 12.00 metres) Longspan steel Sq.m. (NOTE:1 length = 12.00 metres) Zinc sheet
0 0 0
Woodwork Sawn hardwood 150*50mm (NOTE: 1 length = 3.66m) 100*50mm
length
0
length
0
75*50mm
length
0
Wrought hardwood 300*19mm fascia (NOTE: 1 length = 3.66m)
length
0
Fabricated,hot rolled steel angles,BS4360,Grade 43C size: (NOTE: 1 length length==6.00m) 6.00m 50*50*6mm,3.58kg/m
length
0
51*51*6.2mm,4.77kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
75*50*6mm,5.65kg/m
length
0
76*64*9.4mm,9.68kg/m
length
0
76*76*6.2mm,5.96kg/m
length
0
89*64*9.4mm,10.57kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
Fittings and connections 16mm thick mild steel end plates Sq.m.
0
10mm thick mild steel gusset plates
Sq.m.
0
length
0
length
0
length
0
Channel 229*76mm*26.06 kg/m length
0
MATERIALS' ANALYSIS In situ concrete(1:2:4-18mm aggregate) Cement bag
0
Sand
trip
0
Aggregate 18mm
trip
0
Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m (NOTE: 1 length length==6.00m) 6.00m Ditto 102 * 51mm * 10.42 kg/m Ditto 127 * 64mm * 14.90 kg/m
END OF ROOF ELEMENT NO.5 STAIRCASES In situ concrete(1:2:4-18mm aggregate) Staircases Cu.m.
Reinforcement Bars;round mild steel 6mm diameter
0
kg
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
8mm diameter
length
0
10mm diameter
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
0
16mm diameter
length
0
19mm diameter
kg
0
19mm diameter
length
0
25mm diameter
kg
0
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
Formwork,sawn Soffit of staircase & landings
Sq.m.
0
Formwork,sawn Plank
No.
0
Edges of landing slab; not exceeding 250mm
Lin.m.
0
Edges of staircase flights; maximum width 310mm
Lin.m.
0
Edges of risers not exceeding 250mm
Lin.m.
0 0
bag
0
Bars;high yield steel
0
Finishes Beds and backing Cement and sand (1:4) 25mm thick screeded backing Surfaces over 300mm wide
Sq.m.
0
Finishes Beds and backing Cement and sand (1:4) 25mm thick screeded backing Cement
Treads;300mm wide
Lin.m.
0
Sand
trip
0
Risers;150mm high
Lin.m.
0 0 In situ finishings Render,cement and sand (1:6); 15mm thick Cement
bag
0
Sand
trip
0
In situ finishings Render,cement and sand (1:6); 15mm thick Walls;internally
Sq.m.
Soffits of landings
Sq.m.
0
Sloping soffits of staircase
Sq.m.
0
String;not exceeding 300mm girth
Lin.m. 0 STAIRCASE SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Aggregate 18mm
trip
0
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
0
10mm diameter
length
0
12mm diameter
length
0
16mm diameter
length
0
20mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
0
10mm diameter
length
0
12mm diameter
length
0
16mm diameter
length
0
19mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
END OF STAIRCASE
Formwork,sawn Plank
No.
0
ELEMENT NO. 6 INTERNAL AND EXTERNAL WALLS
MATERIALS' ANALYSIS
Concretework In situ concrete Reinforced;(1:2:4 - 18mm agg.) Beams;isolated as lintels
Cu.m.
Walls
Cu.m.
3
Concretework In situ concrete Reinforced;(1:2:4 - 18mm agg.) Cement
bag
18
Sand
trip
1.35
Aggregate
trip
2.4
3
Reinforcement Bars;round mild steel 6mm diameter
kg
8mm diameter
kg
10mm diameter
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length 70
0
8mm diameter
length
21.71
kg
10mm diameter
length
0
12mm diameter
kg
12mm diameter
length
0
16mm diameter
kg
16mm diameter
length
0
20mm diameter
kg
20mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter
kg
32mm diameter
length
0
6mm diameter
kg
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
kg
0
8mm diameter
length
0
10mm diameter
kg
0
10mm diameter
length
0
12mm diameter
kg
170
12mm diameter
length
1.42
16mm diameter
kg
16mm diameter
length
0
19mm diameter
kg
19mm diameter
length
0
25mm diameter
kg
25mm diameter
length
0
32mm diameter Formwork;sawn Sides and soffits of lintels
kg
32mm diameter Formwork;sawn Plank
length
0
Bars;high yield steel
Blockwork Blockwork;sandcrete 450*230mm in cement and sand (1:3)
Sq.m.
31
Blockwork Blockwork;sandcrete 450*230mm in cement and sand (1:3)
No.
8.47
150mm thick
Sq.m.
237
150mm thick
No.
2370
230mm thick
Sq.m.
0 5.45
230mm thick
No.
0
Concrete(1:3) materials for jointing Cement bag
54.51
Sand
trip
INTERNAL AND EXTERNAL WALLS SECTIONAL SUMMARY Cement bag
1.57
72.51
Sand
trip
2.92
Aggregate
trip
2.4
Reinforcement (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
21.71
10mm diameter
length
0
12mm diameter
length
0
16mm diameter
length
0
20mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
Bars;high yield steel (NOTE:1 bar length = 12.00metres) 6mm diameter length
0
8mm diameter
length
21.71
10mm diameter
length
0
12mm diameter
length
1.42
16mm diameter
length
0
19mm diameter
length
0
25mm diameter
length
0
32mm diameter
length
0
Formwork;sawn Plank
No.
8.47
150mm thick
No.
2370
230mm thick
No.
0
MATERIALS' ANALYSIS Internal and External Work In situ finishings Render;cement and sand (1:6) 15mm thick Cement
bag
1701.5
Sand
trip
112.05
Walls;cement and sand (1:3) Screeded backing;12mm thick Cement
bag
10.8
Sand Tiles;slab and block finishings
trip
0.31
150*150*6mm ceramic tiles
No.
4400
Brick facing tiling;size 150 * 60 * 15mm
No.
0
WALL FINISHES SECTIONAL SUMMARY Cement
bag
1712.3
Sand
trip
112.36
150*150*6mm ceramic tiles
No.
4400
Carton of 150*150mm tiles No. (each carton contains 88 pieces)
50
Sandcrete block
ELEMENT NO. 7 WALL FINISHES Internal and External Work In situ finishings Render;cement and sand (1:6) 15mm thick Over 300mm wide;including dressing all reveals,junctions and quoins Sq.m. Curved areas
415
Sq.m. 415
Walls;cement and sand (1:3) Screeded backing;12mm thick To receive ceramic tiles
Sq.m.
Tiles;slab and block finishings Glazed ceramic wall tiling; 150 * 150 * 6mm
Sq.m.
Brick facing tiling;size 150 * 60 * 15mm
Sq.m.
END OF WALL FINISHES
90 1.08
90
Brick facing tiling;size 150 * 60 * 15mm
No.
0
ELEMENT NO. 8 FLOOR FINISHES Internal and External Work Polished in situ terrazo paving; 25mm thick in 1200 * 1200mm bays with an including black ebonite strips Paving internally
Sq. m.
Paving externally
Sq. m.
20 * 100mm high skirting
Lin.m.
Beds and backings Floors;screeded bed 25mm thick to receive quarry tiles 25mm thick to receive terrazo paving
Sq. m.
Sq. m.
32mm thick to receive granite tiling
Sq. m.
Sq. m.
48mm thick to receive PVC floor tiling Sq. m. Tiles;slab and block finishings PVC floor tiles;Dunlop 'Semtex' or 'similar';300 * 300mm fixed with adhesive Flooring;2mm thick PVC floor tiles;Dunlop 'Semtex' or' similar';250 * 250mm fixed with adhesive Flooring;2mm thick
0
Marble
bag
0
Cement : marble ratio = 1:3 Cement
bag
0
Marble
bag
0
Beds and backings Cement
bag
104.64
Sand
trip
3.92
Tiles;slab and block finishings PVC floor tiles;Dunlop 'Semtex' or 'similar';300 * 300mm fixed with adhesive 300 * 300 *2mm PVC floor tiles
No.
0
292
Carton of 300*300mm PVC tiles No. (each carton contains 44 pieces)
0
0 11.1
PVC floor tiles;Dunlop 'Semtex' or' similar';250 * 250mm fixed with adhesive 250 * 250mm PVC floor tiles
0 0
0
Sq. m.
Sq. m.
Approved ceramic floor tiles; in cement mortar (1:3);300 * 300 size Flooring;12mm thick Sq. m. Skirting 100mm high
bag
0
Sq. m.
32mm thick to receive marble tiling
38mm thick to receive ceramic tiling
MATERIALS' ANALYSIS Internal and External Work Polished in situ terrazo paving; 25mm thick in 1200 * 1200mm bays with an including black ebonite strips Cement : marble ratio = 1:2.5 Cement
Lin.m.
0 0
292 0 292
No.
0
Carton of 250*250mm PVC tiles (each carton contains128 pieces) No.
0
Can of approved adhesive
No.
0
Ebonite strip
Length
0
Approved ceramic floor tiles; in cement mortar (1:3);300 * 300 size Ceramic floor tiles 300*300*12mm mm No. Approved colour polished natural
6056.3
marble in cement mortar (1:3); 400 * 400mm size 400 * 400 *19mm marble tiles
Approved colour polished natural marble in cement mortar (1:3); 400 * 400mm size Flooring;19mm thick Sq. m. Skirting 100mm high
0
Lin.m.
No.
0
Approved colour polished natural granite in cement mortar (1:3); 400 * 400mm size 400 * 400 *19mm granite tiles No.
0
FLOOR FINISHES SECTIONAL SUMMARY Cement
bag
104.64
Marble
bag
0
Sand
trip
3.92
300 * 300 *2mm PVC floor tiles
No.
0
Carton of 300*300mm PVC tiles No. (each carton contains 44 pieces)
0
250 * 250mm PVC floor tiles
No.
0
Carton of 250*250mm PVC tiles (each carton contains128 pieces) No.
0
Can of approved adhesive
No.
0
Ebonite strip
Length
0
0 Approved colour polished natural granite in cement mortar (1:3); 400 * 400mm size Flooring;19mm thick Sq. m. Skirting 100mm high
0
Lin.m. 0
Ceramic floor tiles 225 * 225 *12 mm No.
6056.3
400 * 400 *19mm marble tiles
No.
0
END OF FLOOR FINISHES
400 * 400 *19mm granite tiles
No.
0
ELEMENT NO.9 CEILING FINISHES Internal and External Work In situ finishings Render;cement and sand (1:6) Soffits
MATERIALS' ANALYSIS Internal and External Work In situ finishings Render;cement and sand (1:6) Cement
bag
0
Sand
trip
0
Plain sheet finishing 6mm thick hardboard ceiling
Sq.m.
lining on hardwood noggins 600 * 600 * 12mm thick chip board ceiling boards fixed to hardwood noggins
Sq.m.
292 306.6
Sq.m. 0
Suspended ceiling Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick;with and including all timber supports;paint finish Sq.m. Hardwood 50 * 50mm noggins
0 0
Lin.m. 0
12 * 50mm battens
Lin.m. 0
Plain sheet finishing Hardboard ceiling sheets;1200 * 2400 * 6mm thick No. Chipboard ceiling boards;600 * 600 * 12mm thick
No.
0
Suspended ceiling Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick No.
0
Hardwood 50 * 50mm noggins (NOTE: 1 length = 3.66m) 12 * 50mm battens (NOTE: 1 length = 3.66m)
length
0
length
0
CEILING FINISHES SECTIONAL SUMMARY Cement
bag
0
Sand
trip
0
Hardboard ceiling sheets;1200 * 2400 * 6mm thick No.
106.46
Chipboard ceiling boards;600 * 600 * 12mm thick
No.
0
Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick No.
0
END OF CEILING FINISHES
Hardwood 50 * 50mm noggins (NOTE: 1 length = 3.66m) 12 * 50mm battens (NOTE: 1 length = 3.66m)
ELEMENT NO.10 PAINTING Internal and External Work
MATERIALS' ANALYSIS Emulsion paint
gallon
Prepare prime and apply three full finishing coats of emulsion paint;
Gloss paint
gallon
Whitewash primer
drum
General surfaces;over 300mm girth Walls Walls
Primer (gloss)
gallon
Texcote PAINTING
drum
Sq.m.
223
106.46
length
0
length
0
Staircases Walls
Sq.m.
Soffits of landings
Sq.m.
Sloping soffits of staircase
Lin.m.
Ceilings Soffits Suspended slab
Sq.m. 5.54
0
Ditto;150 - 300mm
Lin.m.
0
Ditto;not exceeding 150mm
Lin.m. 0
0 0
Apply two full coats of texcote paint General surfaces;over 300mm girth
221.45 Sq.m.
206 206
Ditto;150 - 300mm
Lin.m.
Ditto;not exceeding 150mm
Lin.m. trip
Gloss paint
gallon
Whitewash primer (25 kg drum) Primer (gloss)
drum
Texcote (30 kg drum)
drum
6.95 0
gallon
0.02 0 7.21
292 515
Painting wood & metal;prime and apply two full coats of gloss paint General surfaces;over 300mm girth Sq.m.
END OF PAINTING Laterite
drum
0
Sq.m.
String;not exceeding 300mm girth
SECTIONAL SUMMARY Emulsion paint
0 4.17
GRAND SUMMARY OF ALL MATERIALS REQUIRED FOR THE PROJECT S/No.
Cement
bag
1975.23
Sand
trip
127.09
Aggregate 40mm
trip
12.6
Aggregate 18mm
trip
3.25
6mm mild steel bar
length
0
8mm ditto
length
21.71
10mm ditto
length
0.83
12mm ditto
length
0
16mm ditto
length
0
20mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
6mm high yield steel bar
length
0
8mm ditto
length
21.71
10mm ditto
length
0
12mm ditto
length
6.53
16mm ditto
length
8.33
19mm ditto
length
0
25mm ditto
length
0
32mm ditto
length
0
BRC
roll
0
Plank
length
225mm block
No.
800
150mm block
No.
2370
Corrugated sheet roofing Long span aluminium Sq.m. (NOTE:1 length = 12.00 metres) Longspan steel (NOTE:1 length = 12.00 metres) Zinc Sq.m.
Woodwork Sawn hardwood 150*50mm (NOTE: 1 length = 3.66m)
length
18.85
0
0
0
100*50mm
length
0
75*50mm
length
0
Wrought hardwood 300*19mm fascia (NOTE: 1 length = 3.66m)
length
0
Fabricated,hot rolled steel angles,BS4360,Grade 43C size: (NOTE: 1 length length==6.00m) 6.00m 50*50*6mm,3.58kg/m
length
0
51*51*6.2mm,4.77kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
75*50*6mm,5.65kg/m
length
0
76*64*9.4mm,9.68kg/m
length
0
76*76*6.2mm,5.96kg/m
length
0
89*64*9.4mm,10.57kg/m
length
0
57*57*6.2mm,5.35kg/m
length
0
Fittings and connections 16mm thick mild steel end plates Sq.m.
0
10mm thick mild steel gusset plates
Sq.m.
0
length
0
length
0
length
0
Channel 229*76mm*26.06 kg/m length
0
Steel to B.S. 4360 Grade 43 Zed purlin 76* 38mm*6.7 kg/m (NOTE: 1 length length==6.00m) 6.00m Ditto 102 * 51mm * 10.42 kg/m Ditto 127 * 64mm * 14.90 kg/m
150*150*6mm ceramic tiles
No.
4400
Carton of 150*150mm tiles No. (each carton contains 88 pieces)
50
Brick facing tiling;size 150 * 60 * 15mm
No.
0
300 * 300 *2mm PVC floor tiles
No.
0
Carton of 300*300mm PVC tiles No. (each carton contains 44 pieces)
0
250 * 250mm PVC floor tiles
No.
0
Carton of 250*250mm PVC tiles (each carton contains128 pieces) No.
0
Can of approved adhesive
No.
0
Ebonite strip
Length
0
Ceramic floor tiles 225 * 225 *12 mm No.
6056.3
400 * 400 *19mm marble tiles
No.
0
400 * 400 *19mm granite tiles
No.
0
Hardboard ceiling sheets;1200 * 2400 * 6mm thick No.
106.46
Chipboard ceiling boards;600 * 600 * 12mm thick
No.
0
Particle board or other approved ceiling sheets;1200 * 2400 * 12.5 mm thick No.
0
Hardwood 50 * 50mm noggins (NOTE: 1 length = 3.66m) 12 * 50mm battens (NOTE: 1 length = 3.66m)
length
0
length
0
Emulsion paint
gallon
6.95
Gloss paint
gallon
0
Whitewash primer
drum
0
Primer (gloss)
gallon
0
Texcote
drum
7.21
END OF MADEBOQ 1
p0
WITHOUT
E SAME OF YOUR T CELLS
