material schedule format - copy

96
INTRODUCTION TO MADEBOQ 1 MADEBOQ I is a programme that can calculate the quantities of materials that are requi in an elemental bills of quantities. MADEBOQ I presents a format that is similar to a page of a typical bills of quantities columns for serialization,description,quantity and unit. All you have to do is to inpu work of your elemental bills of quantities into the corresponding sections of MADEBOQ quantity for concrete in foundations against the corresponding item in MADEBOQ I secti MADEBOQ 1 calls for bulk quantities for items bearing the same specification;rather t quantities as obtained in the bills of quantities.For example;you could have the follo 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 1 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 Unit Quantity In - situ concrete (1:3:6 - 40mm aggregate) in: 1 Foundations Cu.m. 69 The MADEBOQ 1 quantity for foundations is obtained by adding up the individual items o 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 corre description in MADEBOQ 1. You do this by highlighting the appropriate yellow cell, typing your quantity figure i 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 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.MADEB able to calculate the total quantities of each material required in all sections of th MADEBOQ I will give section totals (by which you will be able to ascertain the total m element of the works) and grand totals (by which you will be able to ascertain the tot 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 When you scroll down to the end of each section of MADEBOQ 1,you will be able to obtai of all the materials required for your works. MADEBOQ means Materials Analysis Derived from Bills Of Quantities

Upload: jibril-tauheed

Post on 28-Nov-2014

904 views

Category:

Documents


14 download

TRANSCRIPT

Page 1: Material Schedule Format - Copy

INTRODUCTION TO MADEBOQ 1

MADEBOQ I is a programme that can calculate the quantities of materials that are required for all items of workin 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 measuredwork of your elemental bills of quantities into the corresponding sections of MADEBOQ I.For example,input yourquantity for concrete in foundations against the corresponding item in MADEBOQ I section for substructureMADEBOQ 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 quantitiesin 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 Unit QuantityIn - situ concrete (1:3:6 - 40mm aggregate) in:

1 Foundations Cu.m. 69

The MADEBOQ 1 quantity for foundations is obtained by adding up the individual items of the three bills ofquantities 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 itemdescription in MADEBOQ 1.You do this by highlighting the appropriate yellow cell, typing your quantity figure into the cell and then pressingthe 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 alsoable 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 eachelement of the works) and grand totals (by which you will be able to ascertain the total quantity of materialsrequired 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 quantitiesof all the materials required for your works.

MADEBOQ means Materials Analysis Derived from Bills Of Quantities

Page 2: Material Schedule Format - Copy

CAUTION!!!NEVER PRESS THE DELETE KEY ON ANY CELL WHATSOEVER. SOME OF THE CELLS ARE LOADED WITHMATHEMATICAL FUNCTIONS WHICH WOULD BE ERASED IF YOU PRESS THE DELETE KEY.THUS IF YOUWISH TO INPUT DATA IN A PARTICULAR CELL,JUST HIGHLIGHT THE CELL AND INPUT YOUR DATA,WITHOUTFIRST DELETING THE CONTENTS OF THE CELL.IN THIS CASE ONCE YOU INPUT YOUR DATA,EXCEL WILLAUTOMATICALLY REPLACE THE CURRENT DATA WITH THE NEW DATA YOU HAVE INPUTTED;AT THE SAMETHE PREVAILING MATHEMATICAL FUNTIONS WILL BE PRESERVED TO ENABLE THE PROCESSING OF YOURWORK. 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 itemsBright green cells are for outputting quantities of materials for MADEBOQ 1 items.Grey cells denote unit denomination for all quantitiesGolden cells are for headingsGreen cells are for boundariesTurquoise cells are for margins GOOD LUCK!

MADEBOQ 1 STARTS FROM HEREInsert Quantities from the bills of quantities here Read your quantities here

BILLS OF QUANTITIES MATERIALS' ANALYSIS

ELEMENT NO. 1 - SUBSTRUCTUREs/no Description Unit Quantity Material Unit Quantity

Hardcore fiilingHardcore to make up levels Cu.m. 0 Laterite trip 0

In-situ concrete(1:3:6-40mm aggregate) Concrete (1:3:6-40mm agg.) materialsFoundation Cu.m. 0 Cement bag 0

Other Cu.m. Sand trip 00

Aggregate 40mm trip 0

In situ concrete(1:2:4-18mm aggregate) In situ concrete(1:2:4-18mm aggregate)Foundation Cu.m 0 Cement bag 0

Bed Cu.m 0 Sand trip 0

Column Cu.m 0 Aggregate 18mm trip 0

Beam Cu.m

Other Cu.m 00

In situ concrete (1:10) In situ concrete (1:10)Blinding bed Cu.m Cement bag 0

Page 3: Material Schedule Format - Copy

Sand trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 6mm diameter length 0

8mm diameter kg 0 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

20mm diameter kg 20mm diameter length 0

25mm diameter kg 25mm diameter length 0

32mm diameter kg 32mm diameter length 0

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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 reinforcementBRC Sq.m. 0 BRC roll 0

Formwork;sawn FormworkGeneral surfaces Sq.m. 0 Plank length 0

(NOTE:1 length of plank = 3.66 metres)Columns and beams Sq.m. 0

225mm block No. 0Sawn formwork to edges500mm - 1.00m high Lin.m 0 150mm block No. 0

Sawn formwork to edges Concrete(1:3) materials for jointing

Page 4: Material Schedule Format - Copy

250 - 500mm high Lin.m. Cement bag 0

Sawn formwork to edges Sand trip 0not exceeding 250mm high Lin.m.

0 Concrete(1:6) materials for fillingBrickwork and Blockwork Cement bag 0Blockwork,sandcrete 450*230filled solid with concrete Sand trip 0225mm Sq.m 0

Concrete(1:6) materials for rendering150mm Sq.m Cement bag 0

00 Sand trip 0

SUBSTRUCTURE SECTIONAL SUMMARYRendering Laterite trip 0Cement and sand (1:6)Rendering Sq.m 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 steelbar length 0

8mm ditto length 0

10mm ditto length 0

12mm ditto length 0

16mm ditto length 0

Page 5: Material Schedule Format - Copy

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) In situ concrete(1:2:4-18mm aggregate)Columns Cu.m. 0 Cement bag 0

Beams Cu.m. 0 Sand trip 00

Aggregate 18mm trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 0 6mm diameter length 0

8mm diameter kg 0 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

20mm diameter kg 20mm diameter length 0

25mm diameter kg 25mm diameter length 0

32mm diameter kg 32mm diameter length 0

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 6mm diameter length 0

8mm diameter kg 8mm diameter length 0

10mm diameter kg 0 10mm diameter length 0

12mm diameter kg 12mm diameter length 0

Page 6: Material Schedule Format - Copy

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 0Formwork;sawn FormworkGeneral surfaces Sq.m. 0 Plank length 0

(NOTE:1 length of plank = 3.66 metres)Columns and beams Sq.m. 0

FRAMESawn formwork to edges SECTIONAL SUMMARY500mm - 1.00m high Lin.m Cement bag 0

Sawn formwork to edges Sand trip 0250 - 500mm high Lin.m.

Aggregate 18mm trip 0Sawn formwork to edgesnot exceeding 250mm high Lin.m.

06mm 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 steelbar 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

Page 7: Material Schedule Format - Copy

32mm ditto length 0

END OF FRAME Plank length 0

ELEMENT NO.3 UPPER FLOORS MATERIALS' ANALYSISIn situ concrete(1:2:4-18mm aggregate) In situ concrete(1:2:4-18mm aggregate)Slabs Cu.m. 0 Cement bag 0

Sand trip 0

Aggregate 18mm trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 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 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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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 FormworkGeneral surfaces Sq.m. 0 Plank length 0

Page 8: Material Schedule Format - Copy

(NOTE:1 length of plank = 3.66 metres)Columns and beams Sq.m.

UPPER FLOORSSawn formwork to edges SECTIONAL SUMMARY500mm - 1.00m high Lin.m 0 Cement bag 0

Sawn formwork to edges Sand trip 0250 - 500mm high Lin.m.

Aggregate 18mm trip 0Sawn formwork to edgesnot exceeding 250mm high Lin.m.

06mm 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) In situ concrete(1:2:4-18mm aggregate)Slabs Cu.m. Cement bag 0

Page 9: Material Schedule Format - Copy

Upstand beams Cu.m. Sand trip 0

Roof beams Cu.m. 0 Aggregate 18mm trip 0

Fascia Cu.m.

Other Cu.m.0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 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 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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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 FormworkGeneral surfaces Sq.m. Plank length 0

(NOTE:1 length of plank = 3.66 metres)To columns and beams Sq.m. 0

Sawn formwork to edges500mm - 1.00m high Lin.m

Page 10: Material Schedule Format - Copy

Sawn formwork to edges250 - 500mm high Lin.m.

Sawn formwork to edgesnot exceeding 250mm high Lin.m.

0Roofing RoofingCorrugated sheet roofing Corrugated sheet roofingLongspan aluminium Sq.m 0 Long span aluminium Sq.m. 0

Longspan steel Sq.m Longspan steel Sq.m. 0

Zinc Sq.m 0 Zinc sheet 00

Woodwork WoodworkSawn hardwood Sawn hardwood150*50mm Lin.m. 0 150*50mm length 0

(NOTE: 1 length = 3.66m)100*50mm Lin.m. 0 100*50mm length 0

75*50mm Lin.m. 0 75*50mm length 0

Wrought hardwood Wrought hardwood300*19mm fascia Lin.m. 0 300*19mm fascia length 0

(NOTE: 1 length = 3.66m)

Structural SteelworkFabricated,hot rolled steel Fabricated,hot rolled steelangles,BS4360,Grade 43C angles,BS4360,Grade 43Csize: size:

(NOTE: 1 l length = 6.00m50*50*6mm,3.58kg/m tonne 50*50*6mm,3.58kg/m length 0

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

Page 11: Material Schedule Format - Copy

16mm thick mild steel end plates tonne 16mm thick mild steel end plates Sq.m. 0

10mm thick mild steel gusset 10mm thick mild steel gussetplates tonne plates Sq.m. 0

Unframed steelwork Unframed steelworkSteel to B.S. 4360 Grade 43 Steel to B.S. 4360 Grade 43Zed purlin 76* 38mm*6.7 kg/m tonne Zed purlin 76* 38mm*6.7 kg/m length 0

(NOTE: 1 l length = 6.00mDitto 102 * 51mm * 10.42 kg/m tonne Ditto 102 * 51mm * 10.42 kg/m length 0

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 FinishesBeds and backing Beds and backingCement and sand (1:4) Cement and sand (1:4) 15mm thick screeded backing Sq.m. Cement bag 0

25mm thick ditto Sq.m. Sand trip 0

ROOFSECTIONAL SUMMARYCement 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 steelbar length 0

Page 12: Material Schedule Format - Copy

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

FormworkPlank length 0(NOTE:1 length of plank = 3.66 metres)

Corrugated sheet roofingLong span aluminium Sq.m. 0(NOTE:1 length = 12.00 metres)Longspan steel Sq.m. 0(NOTE:1 length = 12.00 metres)Zinc sheet 0

WoodworkSawn hardwood150*50mm length 0(NOTE: 1 length = 3.66m)100*50mm length 0

75*50mm length 0

Wrought hardwood300*19mm fascia length 0(NOTE: 1 length = 3.66m)

Fabricated,hot rolled steelangles,BS4360,Grade 43Csize:(NOTE: 1 l length = 6.00m50*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

Page 13: Material Schedule Format - Copy

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 connections16mm thick mild steel end plates Sq.m. 0

10mm thick mild steel gussetplates Sq.m. 0

Steel to B.S. 4360 Grade 43Zed purlin 76* 38mm*6.7 kg/m length 0(NOTE: 1 l length = 6.00mDitto 102 * 51mm * 10.42 kg/m length 0

Ditto 127 * 64mm * 14.90 kg/m length 0

Channel 229*76mm*26.06 kg/m length 0

END OF ROOF

ELEMENT NO.5 STAIRCASES MATERIALS' ANALYSISIn situ concrete(1:2:4-18mm aggregate) In situ concrete(1:2:4-18mm aggregate)Staircases Cu.m. 0 Cement bag 0

Sand trip 0

Aggregate 18mm trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 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

Page 14: Material Schedule Format - Copy

32mm diameter kg 32mm diameter length 0

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 6mm diameter length 0

8mm diameter kg 8mm diameter length 0

10mm diameter kg 0 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 Formwork,sawnSoffit of staircase & landings Sq.m. 0 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

0Finishes FinishesBeds and backing Beds and backingCement and sand (1:4) Cement and sand (1:4) 25mm thick screeded backing 25mm thick screeded backing Surfaces over 300mm wide Sq.m. 0 Cement bag 0

Treads;300mm wide Lin.m. 0 Sand trip 0

Risers;150mm high Lin.m. 00

In situ finishings In situ finishingsRender,cement and sand (1:6); Render,cement and sand (1:6);15mm thick 15mm thickWalls;internally Sq.m. Cement bag 0

Soffits of landings Sq.m. 0 Sand trip 0

Sloping soffits of staircase Sq.m. 0

Page 15: Material Schedule Format - Copy

String;not exceeding 300mmgirth Lin.m.

0STAIRCASESECTIONAL SUMMARYCement 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

Formwork,sawnEND OF STAIRCASE Plank No. 0

ELEMENT NO. 6 INTERNAL AND EXTERNAL WALLS MATERIALS' ANALYSIS

Page 16: Material Schedule Format - Copy

Concretework ConcreteworkIn situ concrete In situ concreteReinforced;(1:2:4 - 18mm agg.) Reinforced;(1:2:4 - 18mm agg.)Beams;isolated as lintels Cu.m. 0 Cement bag 0

Walls Cu.m. Sand trip 00

Aggregate trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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 kg 32mm diameter length 0Formwork;sawn Formwork;sawnSides and soffits of lintels Sq.m. 0 Plank No. 0

Blockwork BlockworkBlockwork;sandcrete 450*230mm Blockwork;sandcrete 450*230mmin cement and sand (1:3) in cement and sand (1:3)

Page 17: Material Schedule Format - Copy

150mm thick Sq.m. 150mm thick No. 0

230mm thick Sq.m. 0 230mm thick No. 00

Concrete(1:3) materials for jointingCement bag 0

Sand trip 0

INTERNAL AND EXTERNAL WALLSSECTIONAL SUMMARYCement 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

Page 18: Material Schedule Format - Copy

25mm diameter length 0

32mm diameter length 0

Formwork;sawnPlank No. 0

Sandcrete block

150mm thick No. 0

230mm thick No. 0

ELEMENT NO. 7 WALL FINISHES MATERIALS' ANALYSISInternal and External Work Internal and External WorkIn situ finishings In situ finishingsRender;cement and sand (1:6) Render;cement and sand (1:6)15mm thick 15mm thickOver 300mm wide;including Cement bag 0dressing all reveals,junctions andquoins Sq.m. 0 Sand trip 0

Curved areas Sq.m.0

Walls;cement and sand (1:3) Walls;cement and sand (1:3)Screeded backing;12mm thick Screeded backing;12mm thickTo receive ceramic tiles Sq.m. 0 Cement bag 0

0Sand trip 0

Tiles;slab and block finishings Tiles;slab and block finishingsGlazed ceramic wall tiling;150 * 150 * 6mm Sq.m. 0 150*150*6mm ceramic tiles No. 0

Brick facing tiling;size Brick facing tiling;size150 * 60 * 15mm Sq.m. 150 * 60 * 15mm No. 0

WALL FINISHESSECTIONAL SUMMARYCement bag 0

Sand trip 0

150*150*6mm ceramic tiles No. 0

Carton of 150*150mm tiles No. 0(each carton contains 88 pieces)

Brick facing tiling;sizeEND OF WALL FINISHES 150 * 60 * 15mm No. 0

Page 19: Material Schedule Format - Copy

ELEMENT NO. 8 FLOOR FINISHES MATERIALS' ANALYSISInternal and External Work Internal and External WorkPolished in situ terrazo paving; Polished in situ terrazo paving;25mm thick in 1200 * 1200mm 25mm thick in 1200 * 1200mmbays with an including black bays with an including blackebonite strips ebonite strips Paving internally Sq. m. 0 Cement : marble ratio = 1:2.5

Cement bag 0Paving externally Sq. m.

0 Marble bag 020 * 100mm high skirting Lin.m. 0

Cement : marble ratio = 1:3Beds and backings Cement bag 0Floors;screeded bed25mm thick to receive quarry Marble bag 0tiles Sq. m. 0

Beds and backings25mm thick to receive Cement bag 0terrazo paving Sq. m.

Sand trip 032mm thick to receive marble tiling Sq. m. Tiles;slab and block finishings

PVC floor tiles;Dunlop 'Semtex' 32mm thick to receive granite or 'similar';300 * 300mm fixed tiling Sq. m. with adhesive

300 * 300 *2mm PVC floor tiles No. 038mm thick to receive ceramic tiling Sq. m. Carton of 300*300mm PVC tiles No. 0

(each carton contains 44 pieces)48mm thick to receive PVC floortiling Sq. m. 0 PVC floor tiles;Dunlop 'Semtex'

0 or' similar';250 * 250mm fixedTiles;slab and block finishings with adhesivePVC floor tiles;Dunlop 'Semtex' 250 * 250mm PVC floor tiles No. 0or 'similar';300 * 300mm fixed with adhesive Carton of 250*250mm PVC tilesFlooring;2mm thick Sq. m. (each carton contains128 pieces) No. 0

PVC floor tiles;Dunlop 'Semtex' Can of approvedor' similar';250 * 250mm fixed adhesive No. 0with adhesiveFlooring;2mm thick Sq. m. 0 Ebonite strip Length 0

0Approved ceramic floor tiles; Approved ceramic floor tiles;in cement mortar (1:3);300 * 300 in cement mortar (1:3);300 * 300size sizeFlooring;12mm thick Sq. m. 0 Ceramic floor tiles 300*300*12mm

mm No. 0Skirting 100mm high Lin.m. 0

0 Approved colour polished natural

Page 20: Material Schedule Format - Copy

marble in cement mortar (1:3);400 * 400mm size400 * 400 *19mm marble tiles No. 0

Approved colour polished naturalgranite in cement mortar (1:3);400 * 400mm size

Approved colour polished natural 400 * 400 *19mm marble in cement mortar (1:3); granite tiles No. 0400 * 400mm sizeFlooring;19mm thick Sq. m. 0 FLOOR FINISHES

SECTIONAL SUMMARYSkirting 100mm high Lin.m. Cement bag 0

0Approved colour polished natural Marble bag 0granite in cement mortar (1:3);400 * 400mm size Sand trip 0Flooring;19mm thick Sq. m. 0

300 * 300 *2mm PVC floor tiles No. 0Skirting 100mm high Lin.m.

0 Carton of 300*300mm PVC tiles No. 0(each carton contains 44 pieces)

250 * 250mm PVC floor tiles No. 0

Carton of 250*250mm PVC tiles(each carton contains128 pieces) No. 0

Can of approvedadhesive No. 0

Ebonite strip Length 0

Ceramic floor tiles 225 * 225 *12mm No. 0

400 * 400 *19mm marble tiles No. 0

400 * 400 *19mm END OF FLOOR FINISHES granite tiles No. 0

ELEMENT NO.9 CEILING FINISHES MATERIALS' ANALYSISInternal and External Work Internal and External WorkIn situ finishings In situ finishingsRender;cement and sand (1:6) Render;cement and sand (1:6)Soffits Sq.m. 0 Cement bag 0

Plain sheet finishing Sand trip 06mm thick hardboard ceiling

Page 21: Material Schedule Format - Copy

lining on hardwood noggins Sq.m. 0 Plain sheet finishing0 Hardboard ceiling sheets;1200 *

600 * 600 * 12mm thick chip 2400 * 6mm thick No. 0board ceiling boards fixed tohardwood noggins Sq.m. 0 Chipboard ceiling boards;600 *

0 600 * 12mm thick No. 0Suspended ceilingParticle board or other approved Suspended ceilingceiling sheets;1200 * 2400 * 12.5 Particle board or other approvedmm thick;with and including all ceiling sheets;1200 * 2400 * 12.5timber supports;paint finish Sq.m. mm thick No. 0

0Hardwood Hardwood50 * 50mm noggins Lin.m. 0 50 * 50mm noggins length 0

0 (NOTE: 1 length = 3.66m)12 * 50mm battens Lin.m. 0 12 * 50mm battens length 0

0 (NOTE: 1 length = 3.66m)

CEILING FINISHESSECTIONAL SUMMARYCement 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 approvedceiling sheets;1200 * 2400 * 12.5mm thick No. 0

Hardwood50 * 50mm noggins length 0(NOTE: 1 length = 3.66m)12 * 50mm battens length 0

END OF CEILING FINISHES (NOTE: 1 length = 3.66m)

ELEMENT NO.10 PAINTING MATERIALS' ANALYSISInternal and External Work Emulsion paint gallon

Prepare prime and apply three Gloss paint gallonfull finishing coats of emulsionpaint; Whitewash primer drum

General surfaces;over 300mm Primer (gloss) gallongirthWalls Texcote drumWalls Sq.m. 0 PAINTING

Page 22: Material Schedule Format - Copy

SECTIONAL SUMMARYStaircases Emulsion paint drum 0Walls Sq.m.

Gloss paint gallon 0Soffits of landings Sq.m. 0

Whitewash primer drum 0Sloping soffits of staircase Sq.m. 0 (25 kg drum)

Primer (gloss) gallon 0String;not exceeding 300mmgirth Lin.m. 0 Texcote drum 0

(30 kg drum)CeilingsSoffitsSuspended slab Sq.m. 0

0 0Painting wood & metal;prime andapply two full coats of glosspaintGeneral surfaces;over 300mmgirth Sq.m. 0

Ditto;150 - 300mm Lin.m. 0

Ditto;not exceeding 150mm Lin.m. 00 0

Apply two full coats of texcotepaintGeneral surfaces;over 300mm 0 0girth Sq.m. 0

Ditto;150 - 300mm Lin.m.

Ditto;not exceeding 150mm Lin.m. 0

END OF PAINTINGLaterite trip 0

GRAND SUMMARY OF ALL MATERIALS REQUIRED FOR THE PROJECTS/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

Page 23: Material Schedule Format - Copy

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 steelbar 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

Corrugated sheet roofingLong span aluminium Sq.m. 0(NOTE:1 length = 12.00 metres)Longspan steel(NOTE:1 length = 12.00 metres)Zinc Sq.m. 0

WoodworkSawn hardwood150*50mm length 0(NOTE: 1 length = 3.66m)

Page 24: Material Schedule Format - Copy

100*50mm length 0

75*50mm length 0

Wrought hardwood300*19mm fascia length 0(NOTE: 1 length = 3.66m)

Fabricated,hot rolled steelangles,BS4360,Grade 43Csize:(NOTE: 1 l length = 6.00m50*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 connections16mm thick mild steel end plates Sq.m. 0

10mm thick mild steel gussetplates Sq.m. 0

Steel to B.S. 4360 Grade 43Zed purlin 76* 38mm*6.7 kg/m length 0(NOTE: 1 l length = 6.00mDitto 102 * 51mm * 10.42 kg/m 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 No. 0(each carton contains 88 pieces)

Page 25: Material Schedule Format - Copy

Brick facing tiling;size150 * 60 * 15mm No. 0

300 * 300 *2mm PVC floor tiles No. 0

Carton of 300*300mm PVC tiles No. 0(each carton contains 44 pieces)

250 * 250mm PVC floor tiles No. 0

Carton of 250*250mm PVC tiles(each carton contains128 pieces) No. 0

Can of approvedadhesive No. 0

Ebonite strip Length 0

Ceramic floor tiles 225 * 225 *12mm 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 approvedceiling sheets;1200 * 2400 * 12.5mm thick No. 0

Hardwood50 * 50mm noggins length 0(NOTE: 1 length = 3.66m)12 * 50mm battens length 0(NOTE: 1 length = 3.66m)

Emulsion paint gallon 0

Gloss paint gallon 0

Whitewash primer drum 0

Primer (gloss) gallon 0

Page 26: Material Schedule Format - Copy

Texcote drum 0

END OF MADEBOQ 1

p0

Page 27: Material Schedule Format - Copy

WISH TO INPUT DATA IN A PARTICULAR CELL,JUST HIGHLIGHT THE CELL AND INPUT YOUR DATA,WITHOUT

THE PREVAILING MATHEMATICAL FUNTIONS WILL BE PRESERVED TO ENABLE THE PROCESSING OF YOURWORK. AS A RULE, AT THE END OF YOUR WORK, YOU COULD INPUT ZERO VALUES INTO THE INPUT CELLS

Page 28: Material Schedule Format - Copy
Page 29: Material Schedule Format - Copy

INTRODUCTION TO MADEBOQ 1

MADEBOQ I is a programme that can calculate the quantities of materials that are required for all items of workin 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 measuredwork of your elemental bills of quantities into the corresponding sections of MADEBOQ I.For example,input yourquantity for concrete in foundations against the corresponding item in MADEBOQ I section for substructureMADEBOQ 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 quantitiesin 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 Unit QuantityIn - situ concrete (1:3:6 - 40mm aggregate) in:

1 Foundations Cu.m. 69

The MADEBOQ 1 quantity for foundations is obtained by adding up the individual items of the three bills ofquantities 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 itemdescription in MADEBOQ 1.You do this by highlighting the appropriate yellow cell, typing your quantity figure into the cell and then pressingthe 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 alsoable 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 eachelement of the works) and grand totals (by which you will be able to ascertain the total quantity of materialsrequired 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 quantitiesof all the materials required for your works.

MADEBOQ means Materials Analysis Derived from Bills Of Quantities

Page 30: Material Schedule Format - Copy

CAUTION!!!NEVER PRESS THE DELETE KEY ON ANY CELL WHATSOEVER. SOME OF THE CELLS ARE LOADED WITHMATHEMATICAL FUNCTIONS WHICH WOULD BE ERASED IF YOU PRESS THE DELETE KEY.THUS IF YOUWISH TO INPUT DATA IN A PARTICULAR CELL,JUST HIGHLIGHT THE CELL AND INPUT YOUR DATA,WITHOUTFIRST DELETING THE CONTENTS OF THE CELL.IN THIS CASE ONCE YOU INPUT YOUR DATA,EXCEL WILLAUTOMATICALLY REPLACE THE CURRENT DATA WITH THE NEW DATA YOU HAVE INPUTTED;AT THE SAMETHE PREVAILING MATHEMATICAL FUNTIONS WILL BE PRESERVED TO ENABLE THE PROCESSING OF YOURWORK. 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 itemsBright green cells are for outputting quantities of materials for MADEBOQ 1 items.Grey cells denote unit denomination for all quantitiesGolden cells are for headingsGreen cells are for boundariesTurquoise cells are for margins GOOD LUCK!

MADEBOQ 1 STARTS FROM HEREInsert Quantities from the bills of quantitie here Read your quantities here

BILLS OF QUANTITIES MATERIALS' ANALYSIS

ELEMENT NO. 1 - SUBSTRUCTUREs/no Description Unit Quantity Material Unit Quantity

Hardcore fiilingHardcore to make up levels Cu.m. 15 Laterite trip 4.166667

In-situ concrete(1:3:6-40mm aggregate) 0 Concrete (1:3:6-40mm agg.) materialsFoundation Cu.m. 14 Cement bag 56

0Other Cu.m. 0 Sand trip 6.3

14Aggregate 40mm trip 12.6

In situ concrete(1:2:4-18mm aggregate) In situ concrete(1:2:4-18mm aggregate)Foundation Cu.m 0 Cement bag 6

Bed Cu.m 0 Sand trip 0.43

Column Cu.m 1 Aggregate 18mm trip 0.85

Beam Cu.m

Other Cu.m 01

In situ concrete (1:10) In situ concrete (1:10)Blinding bed Cu.m 1 Cement bag 4.29

Page 31: Material Schedule Format - Copy

Sand trip 0.4

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 6mm diameter length 0

8mm diameter kg 8mm diameter length 0

10mm diameter kg 10 10mm diameter length 0.833333

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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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.115

16mm diameter kg 100 16mm diameter length 8.333333

19mm diameter kg 0 19mm diameter length 0

25mm diameter kg 0 25mm diameter length 0

32mm diameter kg 32mm diameter length 0

Fabric reinforcementBRC Sq.m. 0 BRC roll 0

Formwork;sawn FormworkGeneral surfaces Sq.m. 0 Plank length 10.38251

(NOTE:1 length of plank = 3.66 metres)Columns and beams Sq.m. 0

225mm block No. 800Sawn formwork to edges500mm - 1.00m high Lin.m 0 150mm block No. 0

Sawn formwork to edges Concrete(1:3) materials for jointing

Page 32: Material Schedule Format - Copy

250 - 500mm high Lin.m. 76 Cement bag 15.0144

Sawn formwork to edges Sand trip 0.531234not exceeding 250mm high Lin.m.

38 Concrete(1:6) materials for fillingBrickwork and Blockwork Cement bag 4.48Blockwork,sandcrete 450*230filled solid with concrete Sand trip 0.230971225mm Sq.m 80

Concrete(1:6) materials for rendering150mm Sq.m 0 Cement bag 0

1.840.8 Sand trip 0

SUBSTRUCTURE SECTIONAL SUMMARYRendering Laterite trip 4.166667Cement and sand (1:6)Rendering Sq.m 0 Cement bag 85.7844

Sand trip 7.892205

Aggregate 40mm trip 12.6

Aggregate 18mm trip 0.85

6mm mild steel bar length 0

8mm ditto length 0

10mm ditto length 0.833333

12mm ditto length 0

16mm ditto length 0

20mm ditto length 0

25mm ditto length 0

32mm ditto length 0

6mm high yield steelbar length 0

8mm ditto length 0

10mm ditto length 0

12mm ditto length 5.115

16mm ditto length 8.333333

Page 33: Material Schedule Format - Copy

19mm ditto length 0

25mm ditto length 0

32mm ditto length 0

BRC roll 0

Plank length 10.38251

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) In situ concrete(1:2:4-18mm aggregate)Columns Cu.m. 0 Cement bag 0

Beams Cu.m. 0 Sand trip 00

Aggregate 18mm trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 0 6mm diameter length 0

8mm diameter kg 0 8mm diameter length 0

10mm diameter kg 10mm diameter length 0

12mm diameter kg 0 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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 6mm diameter length 0

8mm diameter kg 8mm diameter length 0

10mm diameter kg 0 10mm diameter length 0

12mm diameter kg 12mm diameter length 0

Page 34: Material Schedule Format - Copy

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 0Formwork;sawn FormworkGeneral surfaces Sq.m. 0 Plank length 0

(NOTE:1 length of plank = 3.66 metres)Columns and beams Sq.m. 0

FRAMESawn formwork to edges SECTIONAL SUMMARY500mm - 1.00m high Lin.m Cement bag 0

Sawn formwork to edges Sand trip 0250 - 500mm high Lin.m.

Aggregate 18mm trip 0Sawn formwork to edgesnot exceeding 250mm high Lin.m.

06mm 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 steelbar 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

Page 35: Material Schedule Format - Copy

32mm ditto length 0

END OF FRAME Plank length 0

ELEMENT NO.3 UPPER FLOORS MATERIALS' ANALYSISIn situ concrete(1:2:4-18mm aggregate) In situ concrete(1:2:4-18mm aggregate)Slabs Cu.m. 0 Cement bag 0

Sand trip 0

Aggregate 18mm trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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 FormworkGeneral surfaces Sq.m. 0 Plank length 0

Page 36: Material Schedule Format - Copy

(NOTE:1 length of plank = 3.66 metres)Columns and beams Sq.m.

UPPER FLOORSSawn formwork to edges SECTIONAL SUMMARY500mm - 1.00m high Lin.m Cement bag 0

Sawn formwork to edges Sand trip 0250 - 500mm high Lin.m.

Aggregate 18mm trip 0Sawn formwork to edgesnot exceeding 250mm high Lin.m.

06mm 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) In situ concrete(1:2:4-18mm aggregate)Slabs Cu.m. Cement bag 0

Page 37: Material Schedule Format - Copy

Upstand beams Cu.m. Sand trip 0

Roof beams Cu.m. Aggregate 18mm trip 0

Fascia Cu.m.

Other Cu.m.0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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 FormworkGeneral surfaces Sq.m. Plank length 0

(NOTE:1 length of plank = 3.66 metres)To columns and beams Sq.m.

Sawn formwork to edges500mm - 1.00m high Lin.m

Page 38: Material Schedule Format - Copy

Sawn formwork to edges250 - 500mm high Lin.m.

Sawn formwork to edgesnot exceeding 250mm high Lin.m.

0Roofing RoofingCorrugated sheet roofing Corrugated sheet roofingLongspan aluminium Sq.m 0 Long span aluminium Sq.m. 0

Longspan steel Sq.m Longspan steel Sq.m. 0

Zinc Sq.m 0 Zinc sheet 00

Woodwork WoodworkSawn hardwood Sawn hardwood150*50mm Lin.m. 0 150*50mm length 0

(NOTE: 1 length = 3.66m)100*50mm Lin.m. 0 100*50mm length 0

75*50mm Lin.m. 0 75*50mm length 0

Wrought hardwood Wrought hardwood300*19mm fascia Lin.m. 0 300*19mm fascia length 0

(NOTE: 1 length = 3.66m)

Structural SteelworkFabricated,hot rolled steel Fabricated,hot rolled steelangles,BS4360,Grade 43C angles,BS4360,Grade 43Csize: size:

(NOTE: 1 l length = 6.00m50*50*6mm,3.58kg/m tonne 50*50*6mm,3.58kg/m length 0

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

Page 39: Material Schedule Format - Copy

16mm thick mild steel end plates tonne 16mm thick mild steel end plates Sq.m. 0

10mm thick mild steel gusset 10mm thick mild steel gussetplates tonne plates Sq.m. 0

Unframed steelwork Unframed steelworkSteel to B.S. 4360 Grade 43 Steel to B.S. 4360 Grade 43Zed purlin 76* 38mm*6.7 kg/m tonne Zed purlin 76* 38mm*6.7 kg/m length 0

(NOTE: 1 l length = 6.00mDitto 102 * 51mm * 10.42 kg/m tonne Ditto 102 * 51mm * 10.42 kg/m length 0

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 FinishesBeds and backing Beds and backingCement and sand (1:4) Cement and sand (1:4) 15mm thick screeded backing Sq.m. Cement bag 0

25mm thick ditto Sq.m. Sand trip 00

ROOFSECTIONAL SUMMARYCement 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 steelbar length 0

Page 40: Material Schedule Format - Copy

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

FormworkPlank length 0(NOTE:1 length of plank = 3.66 metres)

Corrugated sheet roofingLong span aluminium Sq.m. 0(NOTE:1 length = 12.00 metres)Longspan steel Sq.m. 0(NOTE:1 length = 12.00 metres)Zinc sheet 0

WoodworkSawn hardwood150*50mm length 0(NOTE: 1 length = 3.66m)100*50mm length 0

75*50mm length 0

Wrought hardwood300*19mm fascia length 0(NOTE: 1 length = 3.66m)

Fabricated,hot rolled steelangles,BS4360,Grade 43Csize:(NOTE: 1 l length = 6.00m50*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

Page 41: Material Schedule Format - Copy

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 connections16mm thick mild steel end plates Sq.m. 0

10mm thick mild steel gussetplates Sq.m. 0

Steel to B.S. 4360 Grade 43Zed purlin 76* 38mm*6.7 kg/m length 0(NOTE: 1 l length = 6.00mDitto 102 * 51mm * 10.42 kg/m length 0

Ditto 127 * 64mm * 14.90 kg/m length 0

Channel 229*76mm*26.06 kg/m length 0

END OF ROOF

ELEMENT NO.5 STAIRCASES MATERIALS' ANALYSISIn situ concrete(1:2:4-18mm aggregate) In situ concrete(1:2:4-18mm aggregate)Staircases Cu.m. 0 Cement bag 0

Sand trip 0

Aggregate 18mm trip 0

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 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

Page 42: Material Schedule Format - Copy

32mm diameter kg 32mm diameter length 0

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 6mm diameter length 0

8mm diameter kg 8mm diameter length 0

10mm diameter kg 0 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 Formwork,sawnSoffit of staircase & landings Sq.m. 0 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

0Finishes FinishesBeds and backing Beds and backingCement and sand (1:4) Cement and sand (1:4) 25mm thick screeded backing 25mm thick screeded backing Surfaces over 300mm wide Sq.m. 0 Cement bag 0

Treads;300mm wide Lin.m. 0 Sand trip 0

Risers;150mm high Lin.m. 00

In situ finishings In situ finishingsRender,cement and sand (1:6); Render,cement and sand (1:6);15mm thick 15mm thickWalls;internally Sq.m. Cement bag 0

Soffits of landings Sq.m. 0 Sand trip 0

Sloping soffits of staircase Sq.m. 0

Page 43: Material Schedule Format - Copy

String;not exceeding 300mmgirth Lin.m.

0STAIRCASESECTIONAL SUMMARYCement 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

Formwork,sawnEND OF STAIRCASE Plank No. 0

ELEMENT NO. 6 INTERNAL AND EXTERNAL WALLS MATERIALS' ANALYSIS

Page 44: Material Schedule Format - Copy

Concretework ConcreteworkIn situ concrete In situ concreteReinforced;(1:2:4 - 18mm agg.) Reinforced;(1:2:4 - 18mm agg.)Beams;isolated as lintels Cu.m. 3 Cement bag 18

Walls Cu.m. Sand trip 1.353

Aggregate trip 2.4

Reinforcement ReinforcementBars;round mild steel (NOTE:1 bar length = 12.00metres)6mm diameter kg 6mm diameter length 0

8mm diameter kg 70 8mm diameter length 21.714

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

Bars;high yield steel Bars;high yield steel(NOTE:1 bar length = 12.00metres)

6mm diameter kg 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.416667

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 0Formwork;sawn Formwork;sawnSides and soffits of lintels Sq.m. 31 Plank No. 8.469945

Blockwork BlockworkBlockwork;sandcrete 450*230mm Blockwork;sandcrete 450*230mmin cement and sand (1:3) in cement and sand (1:3)

Page 45: Material Schedule Format - Copy

150mm thick Sq.m. 237 150mm thick No. 2370

230mm thick Sq.m. 0 230mm thick No. 05.451

Concrete(1:3) materials for jointingCement bag 54.51

Sand trip 1.57378

INTERNAL AND EXTERNAL WALLSSECTIONAL SUMMARYCement bag 72.51

Sand trip 2.92378

Aggregate trip 2.4

Reinforcement(NOTE:1 bar length = 12.00metres)6mm diameter length 0

8mm diameter length 21.714

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.714

10mm diameter length 0

12mm diameter length 1.416667

16mm diameter length 0

19mm diameter length 0

Page 46: Material Schedule Format - Copy

25mm diameter length 0

32mm diameter length 0

Formwork;sawnPlank No. 8.469945

Sandcrete block

150mm thick No. 2370

230mm thick No. 0

ELEMENT NO. 7 WALL FINISHES MATERIALS' ANALYSISInternal and External Work Internal and External WorkIn situ finishings In situ finishingsRender;cement and sand (1:6) Render;cement and sand (1:6)15mm thick 15mm thickOver 300mm wide;including Cement bag 1701.5dressing all reveals,junctions andquoins Sq.m. 415 Sand trip 112.05

Curved areas Sq.m.415

Walls;cement and sand (1:3) Walls;cement and sand (1:3)Screeded backing;12mm thick Screeded backing;12mm thickTo receive ceramic tiles Sq.m. 90 Cement bag 10.8

1.08Sand trip 0.311811

Tiles;slab and block finishings Tiles;slab and block finishingsGlazed ceramic wall tiling;150 * 150 * 6mm Sq.m. 90 150*150*6mm ceramic tiles No. 4400

Brick facing tiling;size Brick facing tiling;size150 * 60 * 15mm Sq.m. 150 * 60 * 15mm No. 0

WALL FINISHESSECTIONAL SUMMARYCement bag 1712.3

Sand trip 112.3618

150*150*6mm ceramic tiles No. 4400

Carton of 150*150mm tiles No. 50(each carton contains 88 pieces)

Brick facing tiling;sizeEND OF WALL FINISHES 150 * 60 * 15mm No. 0

Page 47: Material Schedule Format - Copy

ELEMENT NO. 8 FLOOR FINISHES MATERIALS' ANALYSISInternal and External Work Internal and External WorkPolished in situ terrazo paving; Polished in situ terrazo paving;25mm thick in 1200 * 1200mm 25mm thick in 1200 * 1200mmbays with an including black bays with an including blackebonite strips ebonite strips Paving internally Sq. m. 0 Cement : marble ratio = 1:2.5

Cement bag 0Paving externally Sq. m.

0 Marble bag 020 * 100mm high skirting Lin.m. 0

Cement : marble ratio = 1:3Beds and backings Cement bag 0Floors;screeded bed25mm thick to receive quarry Marble bag 0tiles Sq. m. 0

Beds and backings25mm thick to receive Cement bag 104.6353terrazo paving Sq. m.

Sand trip 3.91688832mm thick to receive marble tiling Sq. m. Tiles;slab and block finishings

PVC floor tiles;Dunlop 'Semtex' 32mm thick to receive granite or 'similar';300 * 300mm fixed tiling Sq. m. with adhesive

300 * 300 *2mm PVC floor tiles No. 038mm thick to receive ceramic tiling Sq. m. 292 Carton of 300*300mm PVC tiles No. 0

(each carton contains 44 pieces)48mm thick to receive PVC floortiling Sq. m. 0 PVC floor tiles;Dunlop 'Semtex'

11.096 or' similar';250 * 250mm fixedTiles;slab and block finishings with adhesivePVC floor tiles;Dunlop 'Semtex' 250 * 250mm PVC floor tiles No. 0or 'similar';300 * 300mm fixed with adhesive Carton of 250*250mm PVC tilesFlooring;2mm thick Sq. m. (each carton contains128 pieces) No. 0

PVC floor tiles;Dunlop 'Semtex' Can of approvedor' similar';250 * 250mm fixed adhesive No. 0with adhesiveFlooring;2mm thick Sq. m. 0 Ebonite strip Length 0

0Approved ceramic floor tiles; Approved ceramic floor tiles;in cement mortar (1:3);300 * 300 in cement mortar (1:3);300 * 300size sizeFlooring;12mm thick Sq. m. 292 Ceramic floor tiles 300*300*12mm

mm No. 6056.296Skirting 100mm high Lin.m. 0

292 Approved colour polished natural

Page 48: Material Schedule Format - Copy

marble in cement mortar (1:3);400 * 400mm size400 * 400 *19mm marble tiles No. 0

Approved colour polished naturalgranite in cement mortar (1:3);400 * 400mm size

Approved colour polished natural 400 * 400 *19mm marble in cement mortar (1:3); granite tiles No. 0400 * 400mm sizeFlooring;19mm thick Sq. m. 0 FLOOR FINISHES

SECTIONAL SUMMARYSkirting 100mm high Lin.m. Cement bag 104.6353

0Approved colour polished natural Marble bag 0granite in cement mortar (1:3);400 * 400mm size Sand trip 3.916888Flooring;19mm thick Sq. m. 0

300 * 300 *2mm PVC floor tiles No. 0Skirting 100mm high Lin.m.

0 Carton of 300*300mm PVC tiles No. 0(each carton contains 44 pieces)

250 * 250mm PVC floor tiles No. 0

Carton of 250*250mm PVC tiles(each carton contains128 pieces) No. 0

Can of approvedadhesive No. 0

Ebonite strip Length 0

Ceramic floor tiles 225 * 225 *12mm No. 6056.296

400 * 400 *19mm marble tiles No. 0

400 * 400 *19mm END OF FLOOR FINISHES granite tiles No. 0

ELEMENT NO.9 CEILING FINISHES MATERIALS' ANALYSISInternal and External Work Internal and External WorkIn situ finishings In situ finishingsRender;cement and sand (1:6) Render;cement and sand (1:6)Soffits Sq.m. Cement bag 0

Plain sheet finishing Sand trip 06mm thick hardboard ceiling

Page 49: Material Schedule Format - Copy

lining on hardwood noggins Sq.m. 292 Plain sheet finishing306.6 Hardboard ceiling sheets;1200 *

600 * 600 * 12mm thick chip 2400 * 6mm thick No. 106.4583board ceiling boards fixed tohardwood noggins Sq.m. Chipboard ceiling boards;600 *

0 600 * 12mm thick No. 0Suspended ceilingParticle board or other approved Suspended ceilingceiling sheets;1200 * 2400 * 12.5 Particle board or other approvedmm thick;with and including all ceiling sheets;1200 * 2400 * 12.5timber supports;paint finish Sq.m. 0 mm thick No. 0

0Hardwood Hardwood50 * 50mm noggins Lin.m. 50 * 50mm noggins length 0

0 (NOTE: 1 length = 3.66m)12 * 50mm battens Lin.m. 12 * 50mm battens length 0

0 (NOTE: 1 length = 3.66m)

CEILING FINISHESSECTIONAL SUMMARYCement bag 0

Sand trip 0

Hardboard ceiling sheets;1200 *2400 * 6mm thick No. 106.4583

Chipboard ceiling boards;600 *600 * 12mm thick No. 0

Particle board or other approvedceiling sheets;1200 * 2400 * 12.5mm thick No. 0

Hardwood50 * 50mm noggins length 0(NOTE: 1 length = 3.66m)12 * 50mm battens length 0

END OF CEILING FINISHES (NOTE: 1 length = 3.66m)

ELEMENT NO.10 PAINTING MATERIALS' ANALYSISInternal and External Work Emulsion paint gallon

Prepare prime and apply three Gloss paint gallonfull finishing coats of emulsionpaint; Whitewash primer drum

General surfaces;over 300mm Primer (gloss) gallongirthWalls Texcote drumWalls Sq.m. 223 PAINTING

Page 50: Material Schedule Format - Copy

SECTIONAL SUMMARYStaircases Emulsion paint drum 6.9525Walls Sq.m.

Gloss paint gallon 0Soffits of landings Sq.m. 0

Whitewash primer drum 0.015378Sloping soffits of staircase Sq.m. (25 kg drum)

Primer (gloss) gallon 0String;not exceeding 300mmgirth Lin.m. Texcote drum 7.21

(30 kg drum)CeilingsSoffitsSuspended slab Sq.m. 292

5.53625 515Painting wood & metal;prime andapply two full coats of glosspaintGeneral surfaces;over 300mmgirth Sq.m. 0

Ditto;150 - 300mm Lin.m. 0

Ditto;not exceeding 150mm Lin.m. 00 0

Apply two full coats of texcotepaintGeneral surfaces;over 300mm 221.45 206girth Sq.m. 206

Ditto;150 - 300mm Lin.m.

Ditto;not exceeding 150mm Lin.m. 0

END OF PAINTINGLaterite trip 4.166667

GRAND SUMMARY OF ALL MATERIALS REQUIRED FOR THE PROJECTS/No. Cement bag 1975.23

Sand trip 127.0947

Aggregate 40mm trip 12.6

Aggregate 18mm trip 3.25

6mm mild steel bar length 0

8mm ditto length 21.714

Page 51: Material Schedule Format - Copy

10mm ditto length 0.833333

12mm ditto length 0

16mm ditto length 0

20mm ditto length 0

25mm ditto length 0

32mm ditto length 0

6mm high yield steelbar length 0

8mm ditto length 21.714

10mm ditto length 0

12mm ditto length 6.531667

16mm ditto length 8.333333

19mm ditto length 0

25mm ditto length 0

32mm ditto length 0

BRC roll 0

Plank length 18.85246

225mm block No. 800

150mm block No. 2370

Corrugated sheet roofingLong span aluminium Sq.m. 0(NOTE:1 length = 12.00 metres)Longspan steel(NOTE:1 length = 12.00 metres)Zinc Sq.m. 0

WoodworkSawn hardwood150*50mm length 0(NOTE: 1 length = 3.66m)

Page 52: Material Schedule Format - Copy

100*50mm length 0

75*50mm length 0

Wrought hardwood300*19mm fascia length 0(NOTE: 1 length = 3.66m)

Fabricated,hot rolled steelangles,BS4360,Grade 43Csize:(NOTE: 1 l length = 6.00m50*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 connections16mm thick mild steel end plates Sq.m. 0

10mm thick mild steel gussetplates Sq.m. 0

Steel to B.S. 4360 Grade 43Zed purlin 76* 38mm*6.7 kg/m length 0(NOTE: 1 l length = 6.00mDitto 102 * 51mm * 10.42 kg/m 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. 4400

Carton of 150*150mm tiles No. 50(each carton contains 88 pieces)

Page 53: Material Schedule Format - Copy

Brick facing tiling;size150 * 60 * 15mm No. 0

300 * 300 *2mm PVC floor tiles No. 0

Carton of 300*300mm PVC tiles No. 0(each carton contains 44 pieces)

250 * 250mm PVC floor tiles No. 0

Carton of 250*250mm PVC tiles(each carton contains128 pieces) No. 0

Can of approvedadhesive No. 0

Ebonite strip Length 0

Ceramic floor tiles 225 * 225 *12mm No. 6056.296

400 * 400 *19mm marble tiles No. 0

400 * 400 *19mm granite tiles No. 0

Hardboard ceiling sheets;1200 *2400 * 6mm thick No. 106.4583

Chipboard ceiling boards;600 *600 * 12mm thick No. 0

Particle board or other approvedceiling sheets;1200 * 2400 * 12.5mm thick No. 0

Hardwood50 * 50mm noggins length 0(NOTE: 1 length = 3.66m)12 * 50mm battens length 0(NOTE: 1 length = 3.66m)

Emulsion paint gallon 6.9525

Gloss paint gallon 0

Whitewash primer drum 0

Primer (gloss) gallon 0

Page 54: Material Schedule Format - Copy

Texcote drum 7.21

END OF MADEBOQ 1

p0

Page 55: Material Schedule Format - Copy

WISH TO INPUT DATA IN A PARTICULAR CELL,JUST HIGHLIGHT THE CELL AND INPUT YOUR DATA,WITHOUT

AUTOMATICALLY REPLACE THE CURRENT DATA WITH THE NEW DATA YOU HAVE INPUTTED;AT THE SAMETHE PREVAILING MATHEMATICAL FUNTIONS WILL BE PRESERVED TO ENABLE THE PROCESSING OF YOURWORK. AS A RULE, AT THE END OF YOUR WORK, YOU COULD INPUT ZERO VALUES INTO THE INPUT CELLS

Page 56: Material Schedule Format - Copy