BOQ & Billing: Excel par Measurement & Billing Sheet kaise banaye (Step-by-Step Guide) 📊

Aaj ke time par har Site Engineer ko Excel billing system aana chahiye. Manual calculation mein time lagta hai aur errors hone ke chances zyada hote hain.

Is article mein hum seekhenge ki Excel par ek basic billing sheet kaise banayein.

---

1. Basic Sheet Structure

Sabse pehle Excel mein ye columns banayein:

• Item Description
• No (Nos)
• Length (m)
• Breadth (m)
• Height (m)
• Quantity
• Rate
• Amount

---

2. Quantity Calculation Formula

Concrete / Earthwork ke liye:

Formula: Quantity = No × Length × Breadth × Height

Excel Formula:

=B2*C2*D2*E2

---

3. Area Calculation (Plaster / Tiles)

Formula: Area = Length × Height

Excel Formula:

=C2*E2

---

4. Amount Calculation

Formula: Amount = Quantity × Rate

Excel Formula:

=F2*G2

---

5. Total Calculation

Sabhi items ka total nikalne ke liye:

Excel Formula:

=SUM(H2:H20)

---

6. GST Calculation (Optional)

Formula: GST = Total × 18%

Excel Formula:

=H21*18%

---

📊 Sample Billing Table

Description	No	L	B	H	Qty	Rate	Amount
Excavation	1	10	5	2	100	250	25000
Concrete	1	10	5	0.15	7.5	6000	45000

---

🎯 Pro Tips (Site Engineers ke liye)

• Formulas ko drag karke pura sheet auto-fill karein
• Units fix rakhein (m ya ft mix na karein)
• Separate sheet banaein: BOQ, Billing, Summary
• Backup copy hamesha save karein

---

🎯 Conclusion

Excel billing system use karne se aapka kaam fast, accurate aur professional ho jata hai.

Ye skill aapko career growth mein bahut help karegi.

---

💬 Aapka Sawal

Kya aapko Excel formulas samajhne mein problem hoti hai? Comment karein — main advanced template bhi share karunga.