How to Prepare Bar Bending Schedule (BBS) in Excel | How to Make Bar Bending Schedule in Excel

Donate Us if You Like "Free Gyaan" (Donate Amount of Your Choice) - rzp.io/l/OD0h8...
Learn how to prepare Bar Bending Schedule/BBS of a structure with or without the help of computer, basic method for bbs is very easy, Every Civil Engineer Should learn this method on, site. This video will help you a lot in preparing BBS, those who use MS excel and know how to use excel will definitely find this video useful. and those who are new in this field will quickly learn it.
Drawing Link
drive.google.c...
BBS Excel Sheet - rzp.io/l/UvU2RTi
or
Complete set of BBS Which Contains BBS of 10 Structures - rzp.io/l/oeH2GLF
Preparing BBS in excel is very easy in excel if you know the basics of ms excel. at first you need to create format of the sheet you want, you can take the help of the video to create it. the most important things we need is Drawing of the structure, cutting length, and unit weight of the bar. Just gather the information and type in the sheet, that it!
Some other videos that you may be intrested in watching -
1. Pile Foundation Curing Process -
• How to Do Pile Foundat...
2. Pile Foundation Construction Steps in Hindi
• Making of Pile Foundat...
3. Pile Cap Construction Steps
• Pile Cap Construction ...
4. Pile Integrity Test -
• Tests for Pile | Pile ...
5. How to Prepare Construction Process
• How to Prepare Bill fo...
6. How to Prepare BOQ
• Billing Part 1 | How t...
7. Box Culvert
• What is Box Culvert ? ...
8. Box Culvert BBS
• Box Culvert BBS with D...
9. Haunch Bar Cutting Length
• Haunch Bar Cutting Len...
10. Important Shapes in BBS
• Important Shapes with ...
11. PSC Girder Site Video
• PSC Girder Constructio...
12. PSC Girder Stressing Process
• Post Tensioning of PSC...
13. Stone Pitching Measurement
• How to Calculate Stone...
IF YOU LIKED OUR VIDEO 55r LIKE,t5r SHARE AND SUBSCRIBE TO OUR CHANNEL AND GET MORE SUCH VIDEOS, PLASE JOIN US BUY PRESSING JOIN BUTTON.
#BBS #BarBendingSchedule #civilengineering
bbs in excel, bar bending schedule in excel, bar bending schedule, bbs, how to make bbs in excel, bbs in excel sheet, bbs kaise banate hai, bbs kaise nikalte hai, how to make bbs, bbs kaise banaye, bbs civil engineering
bbs in excel
bar bending schedule in excel
bbs in excel sheet
bar bending schedule
bbs
how to make bbs in excel
bbs kaise banaye
how to make bbs
bbs kaise banate hai
bar bending schedule bbs
bbs kaise nikalte hai
bbs kaise nikale
bar bending schedule kaise banate hain
#bbs
bbs civil engineering
civil gyan
bar bending schedule calculation
bbs excel sheet format
excel
excel for civil engineers
bbs of beam
bbs excel
bar bending schedule playlist
box culvert bbs
bbs civil engineer
bbs of beam in excel
how to make bar bending schedule in excel
bbs format
bbs drawing
bbs of column
bar bending schedule interview questions
bbs on excel
box culvert
bbs in civil engineering
bbs calculation in civil engineering
box culvert construction
how to prepare bbs in excel
bbs for civil engineer
bbs excel sheet
excel tutorial
how to make bbs in civil engineering
bbs calculation
bbs of slab
beam bbs
#barbendingschedule
bar bending schedule civil site visit
bbs of footing
bar bending schedule hindi
bbs format in excel
bbs for column
civil guruji
how to make bar bending schedule
bbs civil engineering hindi
how to prepare bbs
bar bending schedule in hindi
civil engineering
column bbs
footing bbs
how to prepare bar bending schedule
ms excel
bar bending
bar bending schedule drawing
bbs for beam
bbs in civil engineer
pile cap bbs
slab bbs
bar bending schedule in excel format free download
bar schedule
bbs schedule
excel formula
ms excel full course in hindi
bar bending schedule for column
bar bending schedule software
bbs for beginners
bbs for slab
bbs of box culvert
box culvert design
box culvert reinforcement details
civil
how to calculate bbs
steel bbs
steel quantity calculation excel sheet
bar bending drawing
bar bending schedule excel
bbs civil guruji
bbs excel sheet formula
bbs in excel tutorial
bbs of footing in excel
civil guruji bbs
culvert design
excel civil engineer
haunch bar calculation formula
ms excel tutorial
what is bar bending schedule
b b s
bar bending schedule bbs problem solving
bar bending schedule for beam
bar bending schedule for slab
bbs of slab in excel
bbs software
bbs steel
beam bbs calculation
beam bbs excel
civil engineering basic knowledge
column bbs in excel
culvert
bar bending schedule for footing
bar bending schedule gate academy
bar bending schedule of column
bar bending schedule of footing
bar bending schedule of slab
bar bending schedule telugu
bar bending shedule
barbending schedule
basic excel formulas and functions
bbs banana
bbs bbs
bbs footing
bbs for box culvert
bbs for footing
bbs in civil
bbs kaise banaya jata hai
bbs making in excel
bbs of column in excel
bbs of pile
bbs of steel
bbs sheet
bbs tutorial

[@CivilGyaan]

BBS Excel Sheet - rzp.io/l/UvU2RTi or Complete set of BBS Which Contains BBS of 10 Structures - rzp.io/l/oeH2GLF

[@akashguddalwar5121]

Sir payment ho gai ab Kai karna honga

[@CivilGyaan]

Aapke Email par aa jayegi file.

[@aakash0727]

Sir aapne bilkul essay way me samjhaya hai dhanywad sir

[@aadarshvikeshprasad]

Video bahut badhiya hai sir

[@shahidahmed8551]

i understood this vedio easily and its very helpful for me . sir please make vedio on running bill for building construction work .

[@royalmakai4956]

I know im randomly asking but does anybody know of a tool to log back into an instagram account..? I somehow forgot the account password. I would love any assistance you can give me!

[@royalmakai4956]

@Gordon Richard I really appreciate your reply. I found the site thru google and im trying it out atm. Seems to take quite some time so I will reply here later when my account password hopefully is recovered.

[@gordonrichard8555]

@Royal Makai glad I could help :D

[@viditrana5792]

Your explanation is too good

[@altamashshaikh1209]

Thank u so much sir ..Very helpful video...

[@dineshyadav-nb2nk]

very well explained sir.. thank you

[@praveen710-4]

For 90 degree turn...there is a 2D formula, not 3D Sir

[@CivilGyaan]

Depends upon the specification of steel..please refer Relative IS Codes..It is not always the case

[@mdbetabansari714]

Thank u sir Very well explain sir

[@pravingodkar8445]

Best explaining 💐

[@pmohammadkhan6412]

Very very very useful bro... Thanks for this this and if u have time to please post total video because i am now learning stage so try to post full Video😊

[@shivasingh-jd1zx]

Great job brother.

[@prabinsingh4]

Ossom video sir Thank you..... sir Stair case ka deatail bbs video banayenge..... Plz

[@imranraza9770]

Very good

[@shankarbogati7612]

Very helpfulcsir

[@tumansingh3110]

Helpful video thanks

[@vinaykumar-ox2nx]

Thank u so much sir.

[@ramdeepkumar7616]

Excellent 👍

[@Suvostructure1995]

Thank you...sir

[@ahmedrjvlogs8780]

Sir, Box culvert ka BBS calculation ka pura video dijiye na sir .... Raft se lekar top slab tak ....A to Z

[@CivilGyaan]

kzbin.info/www/bejne/eGXMkHqderKNpZo Ye dekha kya?

[@sribhagwanyadavyadav3981]

Thanks for ❤️❤️❤️❤️

[@viditrana5792]

Very good sir

[@CivilGyaan]

Readymade Excel Sheet download karne ke liye Description me link check kijiye

[@cheraanthony8193]

Very helpful

[@pushpendrasharma7230]

Nice sir ji

[@Pankaj0096]

Thank you sir. Sir app pura bridge ki drawings video se samjha dijiye sir

[@pramodchouhan5440]

Thx sir

[@abcdefg8680]

Yes

[@mijanulhaque5710]

bohut achaa

[@Thakur_Adarsh_Singh-007]

Thanks a lot sir Hame advance version bhi sikhna ha

[@Er_Bobysingh_CE]

Very nice 👌

[@nanakchand3332]

Thanks Sir

[@er_shubham_ragad3303]

Samz aaya sir

[@mohdmashood5685]

Make 1 vedio Structural Load calculation

[@devendra92able]

sir ...i am having a doubt about the bend...which you have taken as 3d for a 90 degree bend ....as i know for 90 degree bend the multiplying value of the diameter should 2 i.e. 2*d...kindly brief on this....thank you...

[@CivilGyaan]

Yeah you are right! But it depends on specifications of bar, most of the bar used are Medium Tensile Steel Deformed Bars. But in our case it was cold worked steel so the deduction was 3d instead of 2d. You can read IS 2502-1963 for more clarification on this.

[@mayanksharma9007]

Sir Smjh aaya but ye smjha dijiyega ki... Kisi or jagah hm kuch change karte hai to particular kisi cutting length ya total weight vale formula m automatically change ho jata hai... Or Plz ye Vlookup ko BBS m use krna sikhiyayeee Plzz

[@surajdeshmukh8292]

Sir raft top main ka L ka lenght 0.350m kaise lete he

[@sagarpunj324]

👍👍👍👍

[@structuraldrawingsforfresh9437]

Pile ka bbs v banaiye sir

[@bridgeandhighwayengineerin7851]

Isme vertical ka inner and outer face ka bbs bta do aap

[@Suvostructure1995]

Please discuss, vertical bar in varies in 2% slop how to calculate carting length?

[@bridgeandhighwayengineerin7851]

Thanku bhiya🙏 Agr box culvert ka raft 12m*7m ka h to raft me chair kitna lgega ur kitna bend krenge ur kitna size ka chair bnayenge plz 🙏

[@CivilGyaan]

kzbin.info/www/bejne/pWWUe3yji81mldU

[@erkamleshprajapati8368]

Sir please, बताइए फॉर्मूला कैसे बनाते है

[@rajeshtaneja1689]

bend k liye kuch video msin 2d bhi minus karte dekha hai , pl samjhaye ki kitna le

[@CivilGyaan]

kzbin.info/www/bejne/mXqlh5KDbbmJgrM ye video dekh lo, samajh me aa jayega..

[@abcdefg8680]

Highway Road 🛣️ Project ka Esi Type Se Excel v Provide me

[@qamrulhaque1965]

आच्छा है ।

[@CivilGyaan]

👍

[@mohd.ibrahim737]

Sir Plz ye btye ki formula kese lagaye mere formula nhi lgte h

[@ashiqui_mantra18]

Sir DWG km samjh me aaya kaise aap bar mark find of sape aur length find kiye

[@arifkhan-pn4dn]

Video is awesome .... There is no link of drawing in it. Can you provide me the drawing of this video ?

[@CivilGyaan]

I have put a link of drawing in decription on your request, please check.

[@mscivilconstruction2338]

last main total weight kese nikala alag alag dia ka konsa formula use kiya

[@CivilGyaan]

Sumif function

[@akashguddalwar5121]

Sir Excel sheet download kahase download krnana hai after payment

[@naumanakram8786]

Sir In your PSC girder excel sheet, why did you ignore the lap length in the cutting length? Won't it affect the total weight? Please reply thanks.

[@CivilGyaan]

Let me clear you on thing, You are right, it will afftect the weight, but when we make bbs, we do not include the lap length in it, we only take a percentage of that steel as extra, as there is lap, wastages in cutting etc. The lap length should be included in measurement when you are making a bill. Otherwise it is not necessary.

[@CivilGyaan]

And if you wish to include the lap length, then simply make another column and you can show the length with adding lap in it.

[@rajnishshukla871]

Sir we have to add lap length for Accurate weight calculation and also one doubt i have sir why we are not deducting Bend for 90 degree or for example if 90 degree bend we have to deduct 2d please clarify

[@sanjaynagane3200]

for 90 degree bent taking 2d insted of 3d

[@CivilGyaan]

Yes True..but it is not always the case..read IS 2502

[@suniljadhav9817]

very nice video thank you sir. sir plz send me your autocad file in this video. thank you sir.

[@suniljadhav9817]

mail id- [e-mail]

[@umangbhushan7914]

Bend deduction for 90°=2d in the 1st bar.

[@CivilGyaan]

In our case it is however 3d...specified by our consultant.

[@rohitkasyap5658]

Bhiya drawing kaise read kare

[@chennareddyindla2349]

Super explanation. Please send full work out sheet to my whatsapp.

[@CivilGyaan]

Check the description of the video and click the link provided for the excel sheet

[@dwipjyotipal1517]

Sir you didn't explain how to add lapping length... can you please guide me for this?

[@CivilGyaan]

Dear Dwipjyoti, Lap length is not added in BBS at the time of preparation, however reinforcement fixed on site is taken with lap by default. But for your knowledge i will explain how to add laping length in BBS in a separate video. Thank You.

[@dwipjyotipal1517]

@@CivilGyaan thank you so much sir

[@CivilGyaan]

@Dwipjyoti Pal kzbin.info/www/bejne/h6K2mmSZj8StiLs Here is the video for you.

[@dwipjyotipal1517]

@@CivilGyaan thank you sir 🙂🙂🙂

[@brizeshhh]

@@CivilGyaan pls attach link jisme lap length ho add according to favorable and non favorable bond condition. Atutomated formulae wali sheet banana bataiye sir

[@pradeepksinha]

2d minus karaingain sir 90* bend per, and 1d for 45* bend

[@CivilGyaan]

I think you should read IS 2502 Code and get your facts clear about bend deductions.

[@sarfarajgagan278]

for, BEND DEDUCTION, (90 degree = 2D not 3D)

[@CivilGyaan]

Agreed. But our case was different as specifications were different for steel that we used. For more information read IS 2502

[@mohd.ibrahim737]

plz focus on visible

[@Ajit551kumar]

Sir is drawing me c.l of median nahi likha h to kaise pata chalega ki kitna h

[@Ajit551kumar]

Please sir reply

[@bridgeandhighwayengineerin7851]

Sir agar median n diya ho to fr kaise krenge

[@Ajay_ojha872]

Sir top raft ke extra reinforcement ke length 6000mm kaise aayi h?

[@CivilGyaan]

That is wrong, it will be 6.3m

[@Ajay_ojha872]

@@CivilGyaan sir ...6300 nikal rahi ...Ur video help us bahut knowledge h .....Sir can u explain bracket cutting length kaise nikalte h

[@CivilGyaan]

It is very simple to calculate, try it first.

[@brizeshhh]

Aap abhi b ghv me ho kya sir?

[@CivilGyaan]

Nahi, Building Consultancy hai ab, Neemuch (M.P.) me

[@brizeshhh]

@@CivilGyaan very nice mai ratlam me hu ese proper nimbahera se...

[@brizeshhh]

Pls pls it will be a gr8 help for me sir.

[@rajateng.9476]

Sir bend ke liye apne 3D ghataya h, jbki 90° ke liye 2D hota h 🙄

[@CivilGyaan]

Kya kare bhaiya, seniors ko kon samjhaye, wo nahi mante to phir humko "Ram ki jay aur Ravan ki bhi jay" bolni hi padti he, 😇 aap 2d hi kijiye.

[@sambitmishra9721]

Sir i want this drawing bbs excel sheet.

[@CivilGyaan]

Check the description

[@basantsharma1955]

Aapne bar mark 1 ka cutting length nikala hai par usme aapne bottom cover 75 mm minus kiya hai L ka size k liye but mujhe lagta hai sayed top cover v minus hoga 50mm , isliye 1760 k jagah par 1710 hoga , mai toh aapse sikh raha hun , maine sahi kaha or galat , sir mujhe batane ki kripa kare , aur aap is drawing ki pura BBS banaiyega aur hum ko bhi pura structure ko samjhne me aasaan hojaye plz

[@CivilGyaan]

Muje lagta hai aapko abhi clear nahi hai ki cover kisliye diya jaaya hai, cover ka kaam hota hai reinforcement ko rusting se bachana or steel me grip laana, to yeh jaruri nahi ki sab jagah cover minus kiya jaaye, sirf jaha jarurat ho waha cover minus kiya jaata hai, or humko drawing me L ki height nikalne ke liye value di gayi hai, jo 0.3a hai, to isme muje nahi lagta koi confusion hona chahiye.

[@shahbazansari8723]

Sir bbs ka soft copy send kar sakte hai

[@CivilGyaan]

Check link in the description of video

[@vikymehra5902]

90 degree bend ke liye 3d kyu liya?

[@Ajit551kumar]

I am confused that in this drawing the dimensions of the median have not been given so how will we know how much you took 3 meters while making the BBS

[@Ajit551kumar]

Please sir reply

[@CivilGyaan]

As you dont know, there is a book called general notes, which specifies all things of the ongoing project, you can also confirm the width of the median from highway engineer.

[@HD-gb3pv]

2Bhk plan ka BBS nikal ke bhejo

[@ankitkaushik4138]

One 90 pr 2d didection hota he.

[@CivilGyaan]

Fix rule hai kya?, agar hai to batao kaha likha hai?

[@khubarani2020]

Sir unit weight kaise niklte hai

[@CivilGyaan]

kzbin.info/www/bejne/goaqn3ppeLB8oc0 watch this.

[@civilcreators6420]

Sir I need ur email ID I make bbs 2 no bar wall from start to 12.5 I want to check you its OK or some mistake

[@CivilGyaan]

Send it to [e-mail]

[@pawansharma-qo7gb]

Please give me this XL sheet bhai.

[@CivilGyaan]

Please Check the video description. Link is available there.

[@vishwaskumar2351]

90°ke band le liye 2d liya jata hai. Par ap kuch or bata rahe hai.

[@CivilGyaan]

You are right! But our Company was thinking to save steel.

[@manteshsajjan3675]

Haunch formula sir pls send me

[@CivilGyaan]

Watch this video kzbin.info/www/bejne/fIiuqHiip7ppqcU

[@CivilGyaan]

Box Culvert BBS - kzbin.info/www/bejne/eGXMkHqderKNpZo

[@RJTalksonAll]

Sir u took 0.001 value in every formula. .why will u explain formula pls

[@CivilGyaan]

As per your question it seems that you are talking about column I i.e. cutting length column. Look the formula carefully, you will find that all numbers 8,10,12,16 etc. are bar diameter and it is in mm, so to convert these values in meter the value is multiplied by 0.001. Hope you understand this. I urge you to see that column again and you will find the answer. Thank You.

[@RJTalksonAll]

@@CivilGyaan sir i know they are bar diameters. Now i know 0.001 is meter conversion. But next to bar diameter u have taken values 16 to 96 what are these values

[@CivilGyaan]

These are the deduction for bends, in our case it is 2d (for one bend) for dia upto 12 mm and 3d (for 1 bend) for dia greater than 12 mm (Generally it is 3d but due to different specifications of steel it varies). For more information on bending please refer to Note 1, page 6 of IS 2502-1963).

[@RJTalksonAll]

@@CivilGyaan Thanks Sir Now i got it. I was just confused about that values now i understand. How you derived that formula. Thanks sir.

[@sourjyabanik7815]

It's great work by you for young generation .......Thank u very much.....It's also helpful if you provide box culvert drawing, rebar detailing etc & case study of approach slab of box culvert & rebar detail of approach slab..already you prepare video of haunch like this

[@DilipKumar-tk9or]

Plz koi minor bridge ki drawing hobto send kar de is mail id par [e-mail]

[@moviesbazzar9391]

How much profit you made in LT at that time😆

[@CivilGyaan]

My learning was my profit..

[@moviesbazzar9391]

Anyway video is awesome.

[@ameylokhande219]

BBS kiska h

[@CivilGyaan]

What do you mean kiska hai ?

[@ameylokhande219]

@@CivilGyaan BBS for which structure

[@CivilGyaan]

@@ameylokhande219 single span minor bridge

[@singersantoshyadavbihar3280]

Thodi sikhni padegi apko

[@ravipradhan8869]

Very good

[@kamalnahak9720]

Nice sir

[@funner1316]

thank u sir

[@CivilGyaan]

My pleasure, if you liked the video, then subscribe to our channel and give us a thumps up, also get more videos periodically for free.