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

[@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

[@viditrana5792]

Your explanation is too good

[@aadarshvikeshprasad]

Video bahut badhiya hai sir

[@prabinsingh4]

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

[@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

[@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😊

[@mdbetabansari714]

Thank u sir Very well explain sir

[@Pankaj0096]

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

[@altamashshaikh1209]

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

[@mijanulhaque5710]

bohut achaa

[@pravingodkar8445]

Best explaining 💐

[@Thakur_Adarsh_Singh-007]

Thanks a lot sir Hame advance version bhi sikhna ha

[@dineshyadav-nb2nk]

very well explained sir.. thank you

[@tumansingh3110]

Helpful video thanks

[@shivasingh-jd1zx]

Great job brother.

[@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

[@ravipradhan8869]

Very good

[@shankarbogati7612]

Very helpfulcsir

[@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?

[@abcdefg8680]

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

[@viditrana5792]

Very good sir

[@erkamleshprajapati8368]

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

[@mohdmashood5685]

Make 1 vedio Structural Load calculation

[@ramdeepkumar7616]

Excellent 👍

[@surajdeshmukh8292]

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

[@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

[@pushpendrasharma7230]

Nice sir ji

[@sribhagwanyadavyadav3981]

Thanks for ❤️❤️❤️❤️

[@CivilGyaan]

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

[@pramodchouhan5440]

Thx sir

[@mohd.ibrahim737]

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

[@cheraanthony8193]

Very helpful

[@bridgeandhighwayengineerin7851]

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

[@ashiqui_mantra18]

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

[@akashguddalwar5121]

Sir Excel sheet download kahase download krnana hai after payment

[@structuraldrawingsforfresh9437]

Pile ka bbs v banaiye sir

[@vinaykumar-ox2nx]

Thank u so much sir.

[@Suvostructure1995]

Thank you...sir

[@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..

[@Er_Bobysingh_CE]

Very nice 👌

[@Suvostructure1995]

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

[@abcdefg8680]

Yes

[@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.

[@mscivilconstruction2338]

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

[@CivilGyaan]

Sumif function

[@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.

[@er_shubham_ragad3303]

Samz aaya sir

[@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

[@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.

[@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

[@bridgeandhighwayengineerin7851]

Sir agar median n diya ho to fr kaise krenge

[@umangbhushan7914]

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

[@CivilGyaan]

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

[@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

[@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.

[@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.

[@sambitmishra9721]

Sir i want this drawing bbs excel sheet.

[@CivilGyaan]

Check the description

[@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.

[@shahbazansari8723]

Sir bbs ka soft copy send kar sakte hai

[@CivilGyaan]

Check link in the description of video

[@qamrulhaque1965]

आच्छा है ।

[@CivilGyaan]

👍

[@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]

[@rohitkasyap5658]

Bhiya drawing kaise read kare

[@Ajit551kumar]

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

[@Ajit551kumar]

Please sir reply

[@riteshchaudhary7429]

❤

[@vikymehra5902]

90 degree bend ke liye 3d kyu liya?

[@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.

[@sanjaynagane3200]

for 90 degree bent taking 2d insted of 3d

[@CivilGyaan]

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

[@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

[@sagarpunj324]

👍👍👍👍

[@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.

[@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

[@HD-gb3pv]

2Bhk plan ka BBS nikal ke bhejo

[@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.

[@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]

[@ankitkaushik4138]

One 90 pr 2d didection hota he.

[@CivilGyaan]

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

[@pawansharma-qo7gb]

Please give me this XL sheet bhai.

[@CivilGyaan]

Please Check the video description. Link is available there.

[@CivilGyaan]

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

[@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.

[@ameylokhande219]

BBS kiska h

[@CivilGyaan]

What do you mean kiska hai ?

[@ameylokhande219]

@@CivilGyaan BBS for which structure

[@CivilGyaan]

@@ameylokhande219 single span minor bridge

[@manteshsajjan3675]

Haunch formula sir pls send me

[@CivilGyaan]

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

[@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.

[@Civilopediaa]

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

[@moviesbazzar9391]

How much profit you made in LT at that time😆

[@CivilGyaan]

My learning was my profit..

[@moviesbazzar9391]

Anyway video is awesome.

[@singersantoshyadavbihar3280]

Thodi sikhni padegi apko

[@DilipKumar-tk9or]

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

[@imranraza9770]

Very good

[@kamalnahak9720]

Nice sir

[@nanakchand3332]

Thanks Sir