Create Your Excel Sheet Bill Format for Engineering with Ease

Excel sheet bill format for Engineering

dear learner already we have designed a two3 building now we are going for analysis for our footing and design so in this lecture I'm just going to show you that how we'll design a single footing by using ETFs result and a Excel sheet okay so let's say that is our Excel sheet we have uh many Excel sheet available if you need that Excel sheet you may I mean you can visit our website that link given in description we have all types of Excel sheet available in our website so I'll use uh that uh 2 XEL 12 C12 C11 and C12 that name is single footing for rectangle or single footing uh sorry single footing a squ and single footing rectangle okay so uh for that I me that two that to this is the uh latest version of our Excel before that we have to uh complete some work in eabs so here our total service load what is the service load total dead load and life load I have created a combination from here here for service load see all dead load and live load are available with scale one so uh here we can see this is the total load which our foundation will carry now we can uh use a trick here to find out our footing approximate footing size okay so how just simply divide your that uh service load with bearing capacity how just go ahead add a new combo so from here I will go here for service load and I'll give its name FS that means footing size and in scale factor I'll divide that scale factor with our baring capacity so for that uh design my bearing capacity is 2 KSF okay and see here our value is in keep so your bearing capacity should be converted in same unit given here so I'm dividing that with two so here 0.5 then I'll click okay and I'll click okay and go here or support and uh here putting size and FZ then apply okay see here we we are getting our approximate footing size now we'll create group how we'll create group the footing are almost S size are almost similar or footing size are almost similar I'll take them in one category like uh here 251 and here 27 one and 25 and 27 so for that three category for that four footing I'll take that footing uh as a let's say if I consider 5 ft uh 5.5 ft into 5.5 ft that will be 30 2 5 okay so uh for that for this four footing will be 5 ft into 5 ft so I'll go to our AutoCat uh layout and here let's create another layer if you also want to know AutoCat go to our website this course is absolutely free for you and uh learn autocut professionally so click here to add new give it name 14 14 and give here the color so I'll give this color is let's say this color no problem and uh okay and 3 mm 0.3 mm okay then close it now from here select the layer or 14 and take rectangle 5.5 ft give it f sign then press tab then 5.5 ft bit sign modular sign then okay just simply click here crl C uh take it from its Center and place it in the uh uh Center of grid so here one and here another done clear so uh first of all uh we have created our putting size one so I'll give its name crl c crl v paste it here and give its name F1 so footing one or uh if you want to provide a specific name SF on single footing one okay done so s control C copy then take copy it with the reference past it here past it here and P it here done so in this way we have to create all of our uh footing section and footing layout here so uh first of all I'll do it and then I'll go for design see here I have completed my layout for that building I mean footing layout for that building so now I will Design all of the footing to show you how we can design a single footing with very quickly okay so to design that footing I will uh go here I will open a C10 for s s forting design see here a very easy Excel sheet okay and uh if you need any tutorials or any Excel anything just simply visit here k.com then for bangal tutorial here and for English tutorial here uh so I'll now first of all we have to provide the two value so what is the f primc f primc for my case is 28 okay FY is 725 PSI okay then dead load and live load okay before that I'll provide here our bearing capacity in KSF so our bearing capacit is 2 KSF you know and uh depth of footing base from easl now they have important things so I'll discuss about that in later and here I'll provide the fooing size I'll just go here and for which one I'm going to design let's say uh M go to AutoCat here and let's select 6.5 and 6.5 okay for that S4 okay for that s sf4 they have sf4 one and sf4 2 so from uh two which one I'll carry actually so I'll carry the which on are carrying maximum load so I'll go here and it's size is 42 and it size is 38 so I will consider for that one cuz if uh we see that our footing are passing for that uh column so that one will be easily passed because it's load is less than that okay so I'll go here now I'll go to here the service load here is your service loot okay so what is our service loot 84 point I mean total dead Lo plus libraries 84.2 4 something and for that one what what is our column here is our column right click here and I will check for our column size or column size is 10 into 12 okay 10 into 12 so I'll go here I'll provide our column sizes same here C1 and C2 so our column sizes one will be 10 and another will be 10 uh one will be 10 sorry one will one will be 10 and another will be 12 okay fine now uh our average unit weight for conrete and soil it's almost 125 it's it's okay and the main bar we'll use I will use 12 mm cuz uh here our main bar is uh I mean our building is very low I'm only 23 building so I'll not go for 16 mm River and here uh I'll come with it later now here I'll provide our dead load and live Lo okay so what is our dead load and live loads first of all I'll go to rabs and uh here we can see our total load is 100 uh sorry 84 Point let's say 85 take calculator 85 805 and now I'll go for our total dead load so here our dead load I'll click apply sorry I'll click apply our dead load is 59.5 59.5 so 60 let's say 60 so our total dead load will be 60 now what will be our live Lo I'll go to excel here minus 60 so dead Lo will be 25 okay uh dead Lo will be 25 let's say 30 30 uh so this is the value we need or already have provided now we have to go for our next step so what is the next next step now we'll see here everything are under satisfy I mean punching share check and on a Beam share check both are uh satisfying so now what we'll do I'll will uh our footing size is okay and our bottom clear cover it's 3 in for footing it's always 3 in we have to consider it now uh distributed what is the distributed bar uh sorry we have provided main bar and distributed bar now we have to provide the trial effective thickness so what is the effective thickness actually effective uh depth D okay so let's say if I provide 10 in and we are seeing that uh it's satisfying so if we and if we provide 10 in we can see our total thickness T will be uh 13.5 in so if I go for let's say 8 in so for 18 in our punching sh is not satisfying but for on uh o share it's satisfying but uh we have to change many here so for 8 in when we have taken 8 in now we can see that our approximate uh L and B length and width length and width are 6. 7 6.7 okay so when our approximate uh value is 6.7 so we have to Prov it 6 uh let's 75 6.75 okay so for 6.75 we can see our our uh section are not passing so I'll go here for okay 8.5 so for 8.5 also it's not passing so I'll go for 9.5 when we have taken 9.5 it's satisfying okay and we can see our approximate L uh length and okay I will not provide any excess load here also I'll take 2.5 see for 2 it's 6 20 sorry uh for 25 it's uh 6.5 so I'll take our size 6.5 and 6.5 done okay so I think for I'm seeing for 6.5 uh and for 9.5 everything is satisfying now I can go for some lower uh thickness so for uh 12.5 in thickness it's also passing now again I'll go for uh 8.5 let's say it's also passing uh okay so if we consider 12 in thickness footing so it's also passing but I'll not as it is a local work and the only the local worker will handle that no visible engineer will be available here so he can in uh inspect that situation so what I'll do I'll just go for 9.5 okay 13 in or I'll go for 10.5 sorry 10. 10.5 or 14 in thickness okay so uh this is our uh total situation and we can see that our total for 14 in thickness everything is okay and now I'll will uh go for our reinforcement so value are same as here we have to provide here okay so when our uh when we are using a square footing then we have to take that value 6.5 6.5 5on so same both same value will be here okay so and for if you are using rectangular then uh length length and L should be different no problem so here also this value of a will be same as that value so provide 0 uh 0 48 okay so uh 0.48 and 0.48 same now I will I will go for I will go for lower value like uh sorry 0.48 same value 42 so it's 0.48 43 just I will I'll just wait 0 484 P so both are same both are same so when both are same that means our design is okay everything is satisfying our approximate value of a is also same this all are same now this is your detailing clear so 14 in and if we uh consider 12 mm part so our shorter and both Direction um length reinforcement will be for 12 mm at the rate of EX in Center to Center distance that's it so this is the way to design a uh Foundation very quickly so thank you thank you very much and if you need more uh things just search on Google by writing Q leify or visit here here a link everything is given here and also uh tutoral link are given here so thank you thank you very much