DATAEXTRACTION command with Excel, site engineers can reduce quantity calculation time by 70% and eliminate manual entry errors.
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.
Ready to master site engineering?
Join 1000+ engineers. Subscribe to our technical newsletter for weekly site execution guides, BOQ templates, and advanced automation tips.
Subscribe to CivMasterPro