Billing Part 1 | How to Prepare Bill of Quantity (BOQ) in Excel | Contractor Running Bill Format

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ส.ค. 2024
  • Bill Excel Sheet -
    1. Client Bill - rzp.io/l/bKDFNGR8
    2. Contractor Bill - rzp.io/l/6Hk0q...
    Donate Us if You Like "Free Gyaan" (Donate Amount of Your Choice) - rzp.io/l/OD0h8...
    Hii Engineers ! Now Billing is not limited to billing engineers only, We can also do it in an easy way. Here in This Video, I Will teach you How To Prepare Bill In Ms Excel. So Load Your Guns and get set for fire.
    Now, here we are talking about BILL OF QUANTITIES, so if we define it, then the answer itself is hidden in the term, i.e. amount of work done for particular work and in short we call it as bill of quantities, it is made up of two things, 1. Quantity of work and 2. Rate of the particular work, so if we multiply quantity with rate, we get an amount of work done, and both three will generate a Bill of Quantity.
    #civilgyaan #boq #billing_in_excel #civilengineering #billinginexcel #billing_engineering #billingengineer
    Billing Series Next Parts
    Billing Part 2 - • Billing Part 2 | Measu...
    Billing Part 3 - • Billing Part 3 | Steel...
    Billing Part 4 - • Billing Part 4 | Abstr...
    Billing Part 5 - • Billing Part 5 | How t...
    For More Videos Please Subscribe Our Channel
    LIKE SHARE
    #BillingInExcel #BillingEngineer #SiteEngineer
    billing in excel,bill preparation in excel,excel for civil engineers,billing,boq in civil engineering,bill of quantities,highway billing,civil engineer billing course,billing engineer course,billing engineer training,how to become billing engineer,billing engineer civil,boq in excel,what is bill of quantities,hindi,construction running bill format in excel,civil contractor bill format in excel,contractor bill format in excel,biiling course for billing engineer,bill of quantity
    boq meaning,boq in construction,bill of quantity meaning,bill of quantities sample,bill of quantities construction,bill of quantities example,boq of building,bill of quantities example pdf,construction running bill format in excel
    subcontractor bill format in excel,excel sheet bill,civil contractor bill format in excel,civil bill format in excel, civil engineering excel sheets,civil engineering calculation excel sheet,interior works boq, bill kaise banta hai,gst bill kaise banta hai,contractor,construction engineering,civil construction,bridge construction,design and build, billing engineer civil, billing in civil engineering, billing,excel for civil engineers,billing work in computer, billing engineer civil course, boq for civil engineering works, billing work in civil engineering, civil engineering billing work, boq in civil engineering, boq, civil engineering billing excel, civil engineering, billing in excel,
    billing engineer civil
    billing work in computer
    billing in civil engineering
    billing
    boq for civil engineering works
    excel for civil engineers
    billing engineer civil course
    billing work in civil engineering
    civil engineering billing work
    boq
    boq in civil engineering
    billing in excel
    bill of quantities
    civil billing engineer
    civil engineering
    boq kaise banaye
    building estimate in excel
    civil engineering billing excel
    billing kaise karte hai
    civil engineer billing work
    civil guruji
    civil gyan
    ra bills in construction
    construction billing process
    boq in excel
    estimate and costing civil engineering
    excel civil engineer
    excel me bill kaise banaye
    civil engineering basic knowledge
    billing civil engineering
    bill of quantity
    autocad tutorial for civil engineers
    excel
    excel billing system
    billing engineer
    estimation and costing in civil engineering lectures
    estimation and costing in civil engineering gate academy
    how to do billing in civil engineering
    rate analysis of civil engineering
    how to make bill in excel
    how to make boq in excel
    how to make boq for tender
    building estimation and costing
    excel bill sheet
    bill in excel
    estimation and costing in civil engineering
    billing engineer civil tutorial
    excel data entry work
    quantity surveying
    excel bill kaise banaye
    quantity surveying tutorials
    estimate
    ms excel full course in hindi
    excel tutorial
    excel civil engineering
    bill of quantity for building construction
    estimation
    civil billing engineer course
    ms excel
    autocad for civil engineering
    bill of quantities in construction
    civil works construction
    excel for engineers
    estimation of building
    estimating and costing in civil engineering lectures
    how to make estimated bill
    contractor billing process
    billing in excel sheet
    estimate of building in excel
    measurement book in civil engineering
    bill kaise banate hai computer mein
    excel sheet kaise banaye
    how to billing in computer
    boq kaise banate hai
    site engineer work
    excel tutoring
    estimation and costing
    billing and estimation engineer
    civil engineer
    highway engineering
    billing of construction work
    civil
    estimating and costing
    bill of quantity in construction
    excel full course in hindi
    quantity surveying in civil engineering
    billing for civil engineering
    construction billing format in excel
    how to make boq
    measurement sheet in civil engineering

ความคิดเห็น • 236

  • @CivilGyaan
    @CivilGyaan  26 วันที่ผ่านมา +1

    Watch Latest Bill Video (Advanced Billing with SAP) - th-cam.com/video/2LLCMSWtuvg/w-d-xo.html

  • @saifmirza8930
    @saifmirza8930 2 ปีที่แล้ว +6

    Guru ji aap jese help krne bale log mil jay to hr bnda bill Sikh lega ..very very thanks 😊

  • @bchandravlogger
    @bchandravlogger 5 หลายเดือนก่อน +1

    You have gained experience while working, that is why you are working so fast and well in the excel sheet, is it possible that the new pressure boy will be able to work like you. My suggestion to you is that you are understanding well, being a civil engineer I appreciate your art of explaining. You are explaining very well but explain slowly so that children can understand. The children who are understanding from you today through this video, after a year or two in the future, they will also become boss guru and explain to others, this is the custom of the job.

  • @hiteshbarkhane6320
    @hiteshbarkhane6320 ปีที่แล้ว +1

    thank you sir , sir mene ek platform se online course buy kiya he par baha kuch samajh nh ata 1500/- ka tha but isme apne jo bataya he bo pura samajh a gaya , please ise Continue rakhiye sir.

  • @BABA.KI.BAKCHODI
    @BABA.KI.BAKCHODI ปีที่แล้ว +2

    Thank u sir... Sabhi log courses sell krne video bnate h but apne sach m kuch knowledge share kiya h..

  • @itspm0909
    @itspm0909 3 ปีที่แล้ว +21

    No one explain in detail like this..Thank you Sir🙏🏻❤️

  • @be-honestindian3054
    @be-honestindian3054 4 ปีที่แล้ว +4

    Sir aap hamare guru..hai .plz guide us,all time.

  • @deepakkk2360
    @deepakkk2360 7 หลายเดือนก่อน +2

    Thank u bhai ji aaj aapse kafi kuch sikhne ko mila

  • @success555
    @success555 3 ปีที่แล้ว +1

    Hello friend,
    Don't tell like Project Manager don't know how to make a bill. Everyone knows and they cross this Works & position also.
    And your project manager also may be watch your video.
    Anyway you are explaining well.
    All the best. Good Luck.

  • @inzemammohammad6698
    @inzemammohammad6698 3 ปีที่แล้ว +6

    Many many thanks to you sir ❤️❤️❤️❤️❤️❤️❤️❤️💐💐💐💐💐

  • @Thakur_Adarsh_Singh-007
    @Thakur_Adarsh_Singh-007 ปีที่แล้ว

    गुरु जी एक टॉपिक पर और वीडियो बना दीजेए की कोई स्ट्रक्चर कम्पलीट नही हुआ हो तो कैसे लिफ्ट wise पेमेंट करे जैसे रिटेनिंग वाल क्रैश बैरियर etc कोई राफ्ट किया तो कितना दे ताकि अगला भाग जाए तो भी दिक्कत ना हो
    बाकी जबरदस्त वीडियो है आपकी

  • @rajdipchakrabortycivil
    @rajdipchakrabortycivil ปีที่แล้ว +1

    Milion thanks for such an easy way explanations & demonstration . Jab hum 1 ra bill se 2 nd ra bill me jate hey tab ( previos ko up to date pe / this bill ko previous me ) something like that copy/replace karna parta hey . If u plz plz teach us that "copy with value" portion then that will be realy helpful .Thank u sir .

  • @shubhamshukla1548
    @shubhamshukla1548 3 ปีที่แล้ว +4

    Great video for basic Excel sheet

  • @anupdaimary9294
    @anupdaimary9294 3 ปีที่แล้ว +6

    Thank you sir, you have explained very wonderfully 👍👍

  • @navedlodhi9676
    @navedlodhi9676 ปีที่แล้ว +1

    Thanks i really learning your best video 👍👍👍

  • @kamal170408
    @kamal170408 3 ปีที่แล้ว +3

    Superb

  • @AvinashSingh-ti2gz
    @AvinashSingh-ti2gz ปีที่แล้ว

    Sir u r a very gud teacher and I was in billing but now not in job since 3 years may this help me

  • @balasahebgirigoud8673
    @balasahebgirigoud8673 7 หลายเดือนก่อน +1

    Tq so much anna ❤ i follow u r information anna🎉

  • @tanushreeroy9995
    @tanushreeroy9995 ปีที่แล้ว

    Thanks for explaining so deeply.
    Sir ek request hai, calculation ke bhi video banaiye.steel ka weight per sqm mein kaise nikale

  • @ersid1162
    @ersid1162 3 ปีที่แล้ว +3

    Awesome job sir excellent.....we respect you sir.

  • @RahulKumar-ph7ok
    @RahulKumar-ph7ok 2 ปีที่แล้ว +1

    Thank you so much sir for billing video

  • @AnoopKumar-oj7em
    @AnoopKumar-oj7em 3 ปีที่แล้ว +8

    Sir drawing seet se bill kaiss bnta h please btana

    • @pabitrathapa8946
      @pabitrathapa8946 2 ปีที่แล้ว

      Aapako aati hey Bill banane tyo mujevi sikadije na plz

  • @rajnishsingh7881
    @rajnishsingh7881 4 ปีที่แล้ว +3

    Fantastic vedio sr......keep doing

  • @ansarishanealam3811
    @ansarishanealam3811 3 ปีที่แล้ว +4

    Nice video, very well explained

  • @hariprasadtaduru9876
    @hariprasadtaduru9876 2 ปีที่แล้ว +2

    Sir
    Iam Hariprasad working in irrigation department.
    Please send me how to prepare estimate copy in excel

  • @mayanktiwari7022
    @mayanktiwari7022 2 ปีที่แล้ว +1

    Very nice video keep doing and upskilling us thanks you 👍

  • @sunitaverma4935
    @sunitaverma4935 3 ปีที่แล้ว +3

    Thank you very much sir

  • @deepanjalikapilchettri9137
    @deepanjalikapilchettri9137 4 ปีที่แล้ว +6

    Amazing Sir thanku so much.. Helped a lot🙏

  • @sohelranask1022
    @sohelranask1022 4 ปีที่แล้ว +3

    very helpful video ...thank you very much

  • @vrijkishore1135
    @vrijkishore1135 18 วันที่ผ่านมา

    Thankyou sir 🙏

  • @SS-zw4vl
    @SS-zw4vl 3 ปีที่แล้ว +4

    Very well explained 👍

  • @sunilkumardeshmukh8810
    @sunilkumardeshmukh8810 4 ปีที่แล้ว +5

    Sir.. plese explain quantity calculation for Skew slab culvert in details??

  • @erfiroz4162
    @erfiroz4162 ปีที่แล้ว

    Bahut umda

  • @ramdasramsad4814
    @ramdasramsad4814 ปีที่แล้ว

    Sir thanks🙏🙇🙏🙇🙏🙇 bill ka complete knowledge chahiye

  • @srwani4363
    @srwani4363 2 ปีที่แล้ว +1

    Thankyou sir thanks...lot of love and respect.......💋💋💋💋💋❤️❤️❤️❤️❤️❤️❤️

  • @yogeshkumar-zy2vs
    @yogeshkumar-zy2vs 2 ปีที่แล้ว +1

    Sir ji
    FRL se quantity kaise nikalte hai please help me subgrade ka

  • @pratimasahu9215
    @pratimasahu9215 11 หลายเดือนก่อน

    Bhot bdiya ❤

  • @UNKNOWN-mw4mf
    @UNKNOWN-mw4mf 3 หลายเดือนก่อน

    Very nice

  • @user-mv1ht1gq4e
    @user-mv1ht1gq4e ปีที่แล้ว

    Nice explanation, a little different same method iam using

  • @Shahidali088
    @Shahidali088 ปีที่แล้ว

    Awesome sir
    Thank you so much sir.

  • @sandysailent9517
    @sandysailent9517 3 ปีที่แล้ว +2

    Thanku sir nice very help ful video ..plz bbs ka ek video bna dijiye exle sheet pe

    • @CivilGyaan
      @CivilGyaan  3 ปีที่แล้ว

      th-cam.com/video/0wEcN7fpdqk/w-d-xo.html

  • @bgchee
    @bgchee 9 หลายเดือนก่อน

    Thank u sir. plz road billing and measurements par vi and highway drawings reading par vi banaiye

  • @engradnankhan7939
    @engradnankhan7939 4 ปีที่แล้ว +5

    can i get this readymade sheet in xls format ?

  • @aleemaleemuddin4868
    @aleemaleemuddin4868 2 ปีที่แล้ว

    Very nice from Er Aleemuddin

  • @Laxman-Line
    @Laxman-Line ปีที่แล้ว

    Very informative thanku sir..

  • @farooqqureshi1025
    @farooqqureshi1025 2 ปีที่แล้ว +1

    Great sir 👌

  • @faroukmohamed8019
    @faroukmohamed8019 2 ปีที่แล้ว +1

    Can u send me the BOQ excel sheet for electrical work

  • @pratimasahu9215
    @pratimasahu9215 11 หลายเดือนก่อน

    Radhe radhe

  • @user-ef6fm4ni6j
    @user-ef6fm4ni6j ปีที่แล้ว

    Thanks for giving information

  • @rohitsainee5021
    @rohitsainee5021 2 ปีที่แล้ว

    Very helpfull video sir thank you sir

  • @satutmishra521
    @satutmishra521 ปีที่แล้ว

    Upto This bill , This bill , privious bill iska matlab ky hota hi . 4 month ka bill banayege to kaise Fill karege isme.

  • @harshitchouhan1254
    @harshitchouhan1254 2 ปีที่แล้ว +1

    excilent, amazing

  • @NorthEastVisiters_
    @NorthEastVisiters_ 9 หลายเดือนก่อน

    Very nice videos Sir

  • @mdbadsah1792
    @mdbadsah1792 2 ปีที่แล้ว +1

    Barabar sir

  • @rahulmaurya2166
    @rahulmaurya2166 ปีที่แล้ว

    Thank you so much Sir 👍👍👍👍👍👍

  • @anilscorner3960
    @anilscorner3960 2 ปีที่แล้ว

    Boq basis par hum completed work ki payment kaise claim karte hai officially

  • @dheerajsingh4462
    @dheerajsingh4462 ปีที่แล้ว

    Excel pr civil k sare work ki video banay.. All..

  • @shaikhshadab3441
    @shaikhshadab3441 ปีที่แล้ว

    Nice video bhai ☺

  • @syednaqibuddin4534
    @syednaqibuddin4534 ปีที่แล้ว

    MASHA ALLAHU LA QUWWATA ILLA BILLAHI

  • @Funnycandy7
    @Funnycandy7 3 หลายเดือนก่อน

    Thnku sir

  • @harshadshirode2862
    @harshadshirode2862 2 ปีที่แล้ว +1

    NICE ONE EXPLAINED SIR..

  • @RKRaj-mg7ht
    @RKRaj-mg7ht 2 ปีที่แล้ว

    Thanks

  • @sandeepyadav-mu1gq
    @sandeepyadav-mu1gq 2 ปีที่แล้ว

    Thanku sir

  • @HiteshKumar-er7eh
    @HiteshKumar-er7eh ปีที่แล้ว

    Very useful sir thanks

  • @droptarokta1993
    @droptarokta1993 3 ปีที่แล้ว +1

    very good thanks

  • @rahouldaryanani2170
    @rahouldaryanani2170 3 ปีที่แล้ว +2

    Sir you explained it very well... thank you...
    But previous bill ki quantity ke liye formula nahi lagega. Upto this bill ke liye formula lagega this bill + upto previous bill...
    Kyunki upto previous bill ki qty aur amount to last RA bill main rahega na

    • @CivilGyaan
      @CivilGyaan  3 ปีที่แล้ว +1

      Correct, Mene mere dimag me aaya wo kiya, coz kabhi kabhi humse typing error ho jaati hai isliye link karna hi sabse best hai.

    • @rahouldaryanani2170
      @rahouldaryanani2170 3 ปีที่แล้ว

      @@CivilGyaan ji sir

    • @bpsinghdce9642
      @bpsinghdce9642 2 ปีที่แล้ว +1

      @@CivilGyaan thanks lot 🙏👍 bit sir mane excel par work nhi kiya h kase seekhe kya Perticular computer course karna chahiye 👍 please tell me I am Civil Engineer

    • @CivilGyaan
      @CivilGyaan  2 ปีที่แล้ว +1

      Koi course karne ki zaroorat nahi hai, practice karoge to sikh jaoge..channel ke sath regularly bane raho.

  • @hariprasadtaduru9876
    @hariprasadtaduru9876 2 ปีที่แล้ว +1

    HOW T O PREPARE COMPARATIVE STATEMENT ABOVE WORK

  • @aniketgajabe265
    @aniketgajabe265 3 ปีที่แล้ว +1

    Thank you sir❤️

  • @mohdmonish5742
    @mohdmonish5742 ปีที่แล้ว

    Dpr format and work progress ke us par 1 video banaye

  • @AJEETKUMAR-tp8dq
    @AJEETKUMAR-tp8dq ปีที่แล้ว

    all Material use in sqft

  • @AvinashSingh-ti2gz
    @AvinashSingh-ti2gz ปีที่แล้ว

    Sir sap or erp ka tutorial de sakte h kya

  • @vivekcivilvala
    @vivekcivilvala ปีที่แล้ว

    Nice

  • @anassaifi20
    @anassaifi20 2 ปีที่แล้ว +1

    Sir drawing sheet se bill kaise banaye please bataye

  • @annappanaika9590
    @annappanaika9590 3 ปีที่แล้ว +1

    Sir how to use coditional formula in reinforcement of different dia rod in measurements sheet for quantity calculation please send video

    • @CivilGyaan
      @CivilGyaan  3 ปีที่แล้ว

      I have already made a video on this. Here is the link th-cam.com/video/CVff6JSJEWk/w-d-xo.html

  • @anzarulhaque5382
    @anzarulhaque5382 3 ปีที่แล้ว +2

    Please make video about details of billing section. Minimum cover in 4-5 video with details.

  • @AJEETKUMAR-tp8dq
    @AJEETKUMAR-tp8dq ปีที่แล้ว

    Sir material use in sqft for Excel sheet

  • @anujkumar-em9un
    @anujkumar-em9un 2 ปีที่แล้ว

    Thanku so much

  • @askoflife6983
    @askoflife6983 2 ปีที่แล้ว

    Sir please kya aap serf current bill banna sekha sakte hai.. please sir

  • @Easucation
    @Easucation ปีที่แล้ว

    Sir Bridge ke Running Banana Ka video Banae Ge Aap mai Nepal Se hu

  • @mkyvloggerstravelventionmo6878
    @mkyvloggerstravelventionmo6878 3 ปีที่แล้ว +1

    Thank u sir
    You just made my day

  • @sohailshekh8164
    @sohailshekh8164 ปีที่แล้ว

    Sir Gas pipe line ka Bill banaiye

  • @shubhambatra3982
    @shubhambatra3982 3 ปีที่แล้ว +1

    Thanku u sir

  • @faizananwar4067
    @faizananwar4067 2 ปีที่แล้ว +1

    Nice bro, keep it up and thanks🌹❤

  • @manishrodekar7156
    @manishrodekar7156 3 ปีที่แล้ว +1

    Sir yato billing sikhaye ya excel dono mix mat kariye...🙏

  • @mohammadrezarahimi3613
    @mohammadrezarahimi3613 2 ปีที่แล้ว

    thank you sir

  • @chetangaude6733
    @chetangaude6733 2 ปีที่แล้ว +1

    Sir what is meaning of upto this bill and upto previous bill?

    • @CivilGyaan
      @CivilGyaan  2 ปีที่แล้ว +1

      Upto this bill means total quantity/amount till current bill and upto previous bill means total quantity/amount till previous bill.

  • @Laxman-Line
    @Laxman-Line ปีที่แล้ว

    Sir background ka sound disturb kar rha h.....
    Bina sound effect ke hi banao

  • @akashdeep1252
    @akashdeep1252 ปีที่แล้ว

    Filter lagana bataie Chainage pe

  • @arunciviltech8544
    @arunciviltech8544 2 ปีที่แล้ว

    Sir make a video on ms project

  • @Ankit423091
    @Ankit423091 2 ปีที่แล้ว

    Site engineers do all these things in MB with hand written bills

  • @pankajsharma-nh9hh
    @pankajsharma-nh9hh ปีที่แล้ว

    Sir how to print it

  • @rayanabbas4061
    @rayanabbas4061 ปีที่แล้ว

    With drawing

  • @Affu_blogger
    @Affu_blogger 9 หลายเดือนก่อน

    ❤❤❤❤❤

  • @straightforward2458
    @straightforward2458 3 ปีที่แล้ว +1

    Sir Ji Thank You Very Much .

  • @muftitariquemasoodfan6553
    @muftitariquemasoodfan6553 3 ปีที่แล้ว

    Sir aap v GHV INDIA me hi job krte h kiya kiyunki mai v GHV me hi job krta hu waise aap video achcha bnate h

  • @tariqueraja8773
    @tariqueraja8773 ปีที่แล้ว

  • @krrishmane2592
    @krrishmane2592 3 ปีที่แล้ว +1

    Very helpful vidio sir thank you

  • @er.abdulasadidrishi603
    @er.abdulasadidrishi603 3 ปีที่แล้ว +1

    It's very helpful

  • @kuntaldhiman1140
    @kuntaldhiman1140 2 ปีที่แล้ว

    Hi sir
    How to make billing with drawing sheet ??

  • @bridgeandhighwayengineerin7851
    @bridgeandhighwayengineerin7851 4 ปีที่แล้ว

    Good morning sir
    Sir aapne Jo last me btaya h previous bill ka Jo qnty nikala h wo smz me ni aaya ur Jo aapne $ lga ke calculate Kiya h wo sir Kya aap ek baar repeat krenge plz

    • @CivilGyaan
      @CivilGyaan  4 ปีที่แล้ว +1

      Agle video me clear karta hu. Ok