COMPLETE COURSE AND HANDBOOK ON QUANTITY SURVEY/BILL OF QUANTITY/COST ESTIMATION USING PLANSWIFT AND EXCEL (0001)

Step into the world of construction cost management with our Quantity Surveying/Bill of quantity/cost estimation Course — a practical and career-focused training designed to equip you with the skills needed to succeed as a Quantity Surveyor in today’s built environment.

This course covers the core principles and practical techniques of quantity surveying, from cost estimation and tendering to contract administration and project financial management. Learn how to control construction costs, prepare accurate bills of quantities, and ensure projects stay within budget.

WATCH THE VIDEO BELOW TO PREVIEW PACKAGE CONTENT

WATCH THE VIDEO BELOW TO PREVIEW THE HANDBOOK CONTENT.



GO THROUGH THE COMPLETE COURSE TABLE OF CONTENT (SECTION 1) AND THE HANDBOOK TABLE OF CONTENT(SECTION 2) BELOW

SECTION 1

COURSE TABLE OF CONTENT

MODULE 1: Introduction to Quantity Surveying

• Role and responsibilities of a Quantity Surveyor
• Importance of cost control and measurement
• Overview of construction drawings and BOQ
• Types of measurement methods (SMM, NRM, POMI)

MODULE 2: Basics of Construction Drawings

• Understanding architectural, structural, and MEP drawings
• Reading and interpreting floor plans, elevations, and sections
• Identifying measurable items from drawings
• Drawing scale, dimensioning, and annotations.

MODULE 3: Excel for Quantity Surveying

• Setting up a BOQ template in Excel
• Importing PlanSwift data into Excel
• Creating formulas for quantities, rates, and total costs
• Formatting BOQs (Item No, Description, Unit, Qty, Rate, Amount)
• Adding VAT, overhead, and profit calculations
• Creating summary sheets and cost reports
• Excel tips for speed and accuracy (lookup, conditional formatting, etc.)

MODULE4: Quantity Take off using PlanSwift

• Introduction to planswift
• Overview of PlanSwift interface and tools
• Foundation Works (Estimation Through Plan swift) PDF OR SCAN FILE.
• Column Necks (Calculations Through Plan Swift No 1 Take off Software).
• Grade Beam (Calculations Through Plan Swift No 1 Take off Software).
• Slab On Grade (Calculations Through Plan Swift No 1 Take off Software).
• Column In Super Structure(Calculations Through Plan Swift No 1 Take off Software.
• Stairs (Calculations Through Plan Swift No 1 Take off Software).
• Slab (Calculations Through Plan Swift No 1 Take off Software.
• Brick Work (Calculations Through Plan Swift No 1 Take off Software).
• Plaster Works (Calculations Through Plan Swift No 1 Take off Software).
• Tiles And Marble Works(Calculations Through Plan Swift No 1 Take off Software).
• Rate Analysis Manual Calculations.
•  Material Statement Excel Sheet (Imp For Project Planning In Material Resources).
•  Bill Of Quantity (B.O.Q.

MODULE 5: Quantity take Off

• Roofing calculation for capentry and rooofing works
• Window and doors works
• Finishing works
• Mechanical works
• Electrical works
• Rate Analysis Manual Calculations.
• Bill Of Quantity (B.O.Q.

MODULE 5: Real-Life Project Application

• Walkthrough of a full QS project from drawings to BOQ
• Hands-on PlanSwift and Excel work on live project
• Review and correction of common mistakes
• Project presentation and report writing

MODULE 6: Final Assessment & Certification

• Class project submission
• Certificate of Completion

BONUS -

1. FREE PLANSWIFT SOFTWARE AND LICENCE
2. FREE BOQ EXCEL TEMPLATE

SECTION 2

HANDBOOK TABLE OF CONTENT

PART 1: FUNDAMENTALS OF HOUSE PLANNING

CHAPTER 1: INTRODUCTION TO COST ESTIMATION

1.1 Role of Cost Estimation in Modern Construction

1.2 Overview of Bill of Quantities (BOQ)

1.3 Workflow of a Quantity Surveyor

1.4 Introduction to the 5-Bedroom Duplex Case Study

1.5 Project Scope and Assumptions

CHAPTER 2: UNITS, MEASUREMENTS & CURRENCY SYSTEM

2.1 Standard Construction Units (m, m², m³, kg)

2.2 Area and Volume Conversion Methods

2.3 Measurement Rules for BOQ

2.4 USD-Based Pricing System

2.5 Currency Conversion Table ($ to ₦, £, €, etc.)

2.6 Exchange Rate Application in Cost Estimation

CHAPTER 3: DRAWING INTERPRETATION FOR ESTIMATION

3.1 Types of Construction Drawings

3.2 Reading Floor Plans (Ground & First Floor)

3.3 Understanding Elevations and Sections

3.4 Extracting Dimensions from Drawings

3.5 Identifying Measurable Elements

CHAPTER 4: PRE-CONSTRUCTION CALCULATIONS

4.1 Site Clearing Calculation

4.2 Setting Out

4.3 Excavation Volume Calculation

4.4 Cart-Away and Disposal

4.5 Pre-Construction Cost Summary

CHAPTER 5: FOUNDATION CALCULATIONS

5.1 Foundation Layout and Types

5.2 Trench Measurement Calculation

5.3 Blinding Concrete Calculation

5.4 Concrete Mix Ratios (1:2:4, 1:3:6)

5.5 Material Breakdown (Cement, Sand, Aggregate)

5.6 Block Foundation Calculation

5.7 Mortar Requirement

5.8 Backfilling and Compaction

CHAPTER 6: STRUCTURAL FRAME CALCULATIONS

6.1 Column Layout and Spacing

6.2 Column Concrete Volume

6.3 Column Reinforcement Calculation

6.4 Beam Volume Calculation

6.5 Beam Reinforcement Estimation

6.6 Slab Area and Thickness

6.7 Slab Concrete Volume

6.8 Reinforcement per m²

CHAPTER 7: REINFORCEMENT (STEEL) CALCULATIONS

7.1 Types of Reinforcement Bars

7.2 Steel Weight per Meter Formula

7.3 Bar Bending Schedule (BBS)

7.4 Total Steel Quantity (kg and tons)

7.5 Steel Cost Calculation (USD)

CHAPTER 8: WALLING CALCULATIONS

8.1 External Wall Area Calculation

8.2 Internal Partition Wall Calculation

8.3 Block Quantity Estimation

8.4 Mortar Mix and Quantity

8.5 Cement Requirement per m²

8.6 Lintel Beam Calculation

8.7 Ring Beam Estimation

CHAPTER 9: STAIRCASE CALCULATIONS

9.1 Stair Geometry (Rise and Tread)

9.2 Staircase Concrete Volume

9.3 Reinforcement Calculation

9.4 Finishing Cost

CHAPTER 10: ROOFING CALCULATIONS

10.1 Roof Type Selection

10.2 Roof Area Calculation (Including Pitch)

10.3 Roofing Sheet Quantity

10.4 Timber Member Estimation

10.5 Accessories and Fixings

10.6 Roofing Cost Calculation

CHAPTER 11: FINISHING WORK CALCULATIONS

11.1 Plastering Area Calculation

11.2 Mortar Requirement for Plastering

11.3 Screeding Volume Calculation

11.4 Painting Area and Paint Quantity

11.5 Tiling Quantity (Floor and Wall)

11.6 Ceiling Area and Material Estimation

CHAPTER 12: DOORS, WINDOWS & FIXTURES

12.1 Door Schedule and Quantity

12.2 Window Area Calculation

12.3 Frame and Installation Cost

12.4 Fixtures and Fittings

CHAPTER 13: MECHANICAL, ELECTRICAL & PLUMBING (MEP)

13.1 Water Supply Pipe Calculation

13.2 Drainage System Estimation

13.3 Sanitary Fixtures Quantification

13.4 Electrical Point Estimation

CHAPTER 14: RATE ANALYSIS

14.1 Rate Build-Up Method

14.2 Material + Labour Cost Breakdown

14.3 Cost per m³ (Concrete)

14.4 Cost per m² (Blockwork, Finishes)

14.5 Equipment and Overhead Cost

14.6 Profit Margin Strategy

CHAPTER 15: FULL BILL OF QUANTITIES (BOQ)

15.1 BOQ Structure and Format

15.2 Substructure Cost Breakdown

15.3 Superstructure Cost Breakdown

15.4 Finishing Cost Breakdown

15.5 MEP Cost Breakdown

15.6 Total Project Cost Summary (USD)

CHAPTER 16: CURRENCY CONVERSION & GLOBAL ADJUSTMENT

16.1 USD-Based Costing System

16.2 Conversion to Local Currencies

16.3 Exchange Rate Application

16.4 Labour Cost Adjustment by Region

16.5 Inflation and Market Variation

CHAPTER 17: COMPLETE CASE STUDY – DUPLEX

17.1 Project Description and Assumptions

17.2 Quantity Take-Off (Step-by-Step)

17.3 Material Cost Calculation (USD)

17.4 Labour Cost Breakdown

17.5 Total Project Cost Range

17.6 Cost Optimization Strategies

CHAPTER 18: TEMPLATES & PRACTICAL TOOLS

18.1 BOQ Template

18.2 Concrete Calculation Sheet

18.3 Blockwork Calculator

18.4 Rate Analysis Template

18.5 Excel Cost Estimation Guide

CHAPTER 19: PRACTICE QUESTIONS & EXERCISES

19.1 Foundation Calculation Exercises

19.2 Concrete Volume Problems

19.3 Blockwork Estimation Tasks

19.4 Mini BOQ Project

19.5 Solutions and Explanations

CHAPTER 20: HOW TO MAKE MONEY WITH THIS SKILL

20.1 Freelancing in Cost Estimation

20.2 How to Charge Clients (USD & Local Rates)

20.3 Finding Clients (Online & Offline)

20.4 Proposal and Quotation Writing

20.5 Building a Cost Consultancy Business