Skip to main content

Fire Fighting Rate Analysis Excel (DAR Based) | Wet Riser + Sprinkler


🔥 Fire Fighting Rate Analysis (DAR Based Excel Template)

By Afroz Civil

Complete Ready-Made Rate Analysis Template for Fire Fighting Systems

Accurate rate analysis is one of the most critical tasks in any construction or MEP project. To simplify this process, Afroz Civil brings you a professionally developed Fire Fighting Rate Analysis Excel Template, fully based on Delhi Analysis of Rates (DAR).

This template is designed to help engineers prepare accurate, fast, and standardized rate analysis without the need for complex calculations.

⚙️ How This Template Works

This Excel template is fully automated and user-friendly.

✔ What You Need to Do:

  • Enter Material Rates

  • Enter Labour Rates

🔄 What Happens Next:

  • The final rate is automatically calculated instantly

No manual formulas or calculations are required.

🚫 Important Instructions

  • All material consumption constants are already fixed as per DAR standards

  • All labour constants are predefined based on standard norms

  • ❌ Do NOT modify constants

  • ✔ Only update the rates

This ensures:

  • Standardization

  • Accuracy

  • Professional output

🧯 Scope of Work Covered

This template covers complete rate analysis for the following fire fighting systems:

🔹 1. Wet Riser & Sprinkler System

Includes detailed rate analysis for:

  • Electric Driven Main Fire Pump

  • Diesel Engine Driven Fire Pump

  • Pressurization Pump

  • Terrace Pump

  • Heavy Duty MS Pipes (Underground & Above Ground)

  • Hydrant Valve

  • Butterfly Valve

  • Non-Return Valve (NRV)

  • Y-Strainer (Stainless Steel)

  • RRL Hose

  • Hose Reel

  • Gun Metal Branch Pipe

  • Fire Brigade Connection

  • Air Vessel

  • Bulb Type Sprinklers

  • Pressure Switch

  • Flow Switch

  • Control Valve

  • Flexible Sprinkler Pipe

  • Deluge Valve

  • Water Curtain Nozzle

  • Trim Assembly

  • Adjustable Rosette Plate

🔹 2. Fire Detection & Alarm System

✔ Conventional System:

  • Heat Detectors

  • Smoke Detectors

  • Manual Call Points

  • Response Indicators

  • Fire Alarm Sounders

  • Talk Back System

  • Control Panel

✔ Intelligent Addressable System:

  • Main Fire Alarm Panel

  • Graphical Fire Monitoring System

  • Repeater Panel

  • Addressable Smoke & Heat Detectors

  • Fault Isolator

  • Fire Control Module

  • Addressable Phone Module

  • Duct Detector

  • Manual Call Point

  • Hooter / Strobe

  • Fire Fighter Telephone System

✔ Public Address System:

  • Voice Alarm Controller

  • Ceiling Speakers

  • Wall Mounted Speakers

  • Audio Amplifiers

  • Directional Speakers

  • Voice Command Keypad

✔ Accessories & Cabling:

  • PVC / ABS Pipes

  • Cabling & Wiring

💡 Key Features of This Template

  • ✔ Fully based on Delhi Analysis of Rates (DAR)

  • ✔ Ready-to-use professional Excel format

  • ✔ No manual calculation required

  • ✔ Saves significant time

  • ✔ Reduces errors in estimation

  • ✔ Suitable for BOQ, tendering, and billing work

🎯 Who Should Use This Template?

  • Civil Engineers

  • MEP Engineers

  • Quantity Surveyors

  • Billing Engineers

  • Contractors

  • Engineering Students

🚀 What You Get

  • Accurate and standardized rate analysis

  • Professional output ready for submission

  • Simplified estimation workflow

  • Real-project level calculation structure


Fire Fighting RA (Riser+Sprinkler+Alarm) Toolkit


 Watch What’s Inside the Excel Template Folder 📂







📌 Final Note

This is not just an Excel sheet — it is a complete professional system based on real project standards. By using this template, you ensure that your rate analysis is aligned with industry practices and DAR guidelines.

🙏 About Afroz Civil

Afroz Civil is committed to delivering practical civil engineering knowledge, tools, and resources that help engineers improve their skills and work efficiency on real projects.

Labels:

Comments

Post a Comment

Popular posts from this blog

IS 1200 All Parts (1 to 28) – Free Download PDF for Site Engineers & Billing

Method of Measurement IS Codes – Afroz Civil 👷 Introduction In civil engineering projects, measurement is the foundation for estimation, costing, billing, and project planning . Without a standard method, every engineer or contractor may interpret work differently. To remove this confusion, the Bureau of Indian Standards (BIS) published IS 1200 – Method of Measurement of Building & Civil Engineering Works . These codes ensure uniformity, transparency, and accuracy in construction measurement. Whether you are a Site Engineer, Billing Engineer, Project Manager, Contractor, or Client , IS 1200 is a must-have reference. At Afroz Civil , we have compiled the complete list of IS 1200 parts with free PDF download links so you can easily save them in your Laptop/PC and use them whenever required on site. 📚 IS 1200 – Method of Measurement (All Parts) IS Code Part Work Description Download Link (PDF) IS1200 Part 1 Earthwork Download PDF IS 1200 Part 2 Concr...
Post a Comment
Read more

Rate Analysis Excel Sheet Download | AOR, SOR, DSR Templates – Afroz Civil

About Rate Analysis   Rate Analysis, Civil Engineering, AOR, SOR, DAR, Labour Output Constants, Construction Estimation, Costing, Billing, Material Cost, Machinery Cost, Afroz Civil Rate Analysis in civil engineering is a complete scientific method used to calculate the actual unit cost of construction activities. A proper rate analysis includes the breakdown of material, labour, machinery, overheads, contractor profit, taxes , and productivity norms. Accurate rate analysis ensures transparent billing , precise estimation , cost control , and efficient project management . It forms the foundation of the Analysis of Rates (AOR) and aligns with the Schedule of Rates (SOR/DAR) published by CPWD, PWD and State Engineering Departments. These codes help engineers maintain standard, uniform and technically correct cost calculations across all construction activities. Abbreviations Used in Rate Analysis: In this article, several important engineering abbreviations have been used, an...
Post a Comment
Read more

BOQ – Bill of Quantity: Meaning, Steps, Format & Complete Guide | Afroz Civil

BOQ – Bill of Quantity: Complete Guide for Civil Engineers By Afroz Civil What is BOQ (Bill of Quantity)? A Bill of Quantity (BOQ) is a structured document prepared by a Quantity Surveyor or Estimator that lists every item of work along with its description, quantity, unit of measurement, rate, and total amount . It is developed based on approved drawings and project specifications and follows standard measurement methods. BOQ brings accuracy, clarity, and transparency to project costing and tendering. Objectives of BOQ To provide item-wise detailed quantities for all project components To offer a uniform basis for contractor bidding To ensure accuracy in estimation and tender comparison To avoid disputes during execution and billing To support interim and final bill preparation Applicable Standards BOQ preparation follows these major codes and references: IS 1200 – Method of Measurement of Building & Civil Works CPWD Works Manual & DSR Mo...
Post a Comment
Read more

Social Media