Skip to main content

Estimation || How to make Bar Shape in Excel Sheets

 The Estimate is the Probable quantity and cost of a work and is determined theoretically by mathematical calculation based on the drawing and current rates and  a stair is a set of steps provided in a building for movement from one floor to another.

So let’s go step by step to learn how to make bar shapes in Excel sheets.

Step 1

First of all we will need an Excel Sheet & then we will go to the insert option. 

Step 2

Next we’ll have to select the shapes & there whatever shapes you are wanting for,  you can select that from there like if you are making a stirrup so you will have to choose a rectangle After that we will make rectangle on the excel sheet and After that we can change the colours also by selecting the white abc portion and the you can change the colour also by selecting shape outline & you can change the line weight also by choosing weight option. 

 

 

 

Step 3

After that you can select the line from the shapes & you can make the desired shapes. And you can group the shapes by selecting all lines & then left click on the mouse  you will have the group option.

So like this you can create any desired shapes in Excel.


For more details, watch this: 

How to make Bar Shapes of BBS in Excel Sheet  || Estimation Tutorial


About us: Civil Center is a Civil Engineering Consultancy company which provides services ranging from Building Consultancy Services like Architectural Plan, Structural Drawing, Estimation, 3D Views of Interior and Exterior of a Building, Construction Planning and Management, and also other services like Survey Investigation Works.


We also provide Industrial Training to Civil Engineering Students as well as professionals which include courses on Building Design, Detailing Estimation, 3D Modelling and Survey  by using Software like STAAD. Pro, Tekla Structural Designer, Revit Structures, Tekla Structures, MS Excel, E-Survey. In training our goal is to make our trainees ready for the industry by getting them trained in Live Projects. We also provide placement assistance to our trainees.

To join our live classes on Tekla Structural Designer and other courses related to Civil Engineering, click here : https://forms.gle/Yy9j8BH8zZzmFfZMA

For any query 

Call on: 8433248864

WhatsApp: +91 6372905201

Email: team@civilcenter.in


If you have any requirement of Building Consultancy Services like Architectural Plan, Structural Drawings etc., register using the link given below

https://forms.gle/M4MTqgcLP6ZEp4rs7

Whatsapp: +91 6372905201

Email: enquiry@civilcenter.in

Visit our Website: http://www.civilcenter.in/


Visit our Website: http://www.civilcenter.in/


You Can Find Us On Other Social Media

Follow us on Telegram :https://t.me/civilcenter17

Visit our Facebook Page: https://www.facebook.com/civilcenter/

Visit our LinkedIn Page: https://www.linkedin.com/company/civil-center

Follow our Twitter Handle: https://twitter.com/_CivilCenter

Follow us on Instagram: https://www.instagram.com/civilcenter17/


Comments

Popular posts from this blog

Tekla structural Designer VS ETABS.

Tekla Structural Designer is advanced software used for Structural Analysis and Design of a Building. In Tekla, we can do the detailing of steel structures as well as RCC structures. We can create RCC buildings and we can insert the rebars in Tekla structures Designer software.  We can also do the form works and structural drawing without the help of any other software. Let’s see the difference between TSD and ETABS. Step 1 As per the modelling aspects in ETABS we can import the grid lines we cannot import the shadow of an architectural drawing and in Tekla, we can import grid lines as well as the shadow of an architectural drawing assigning beams and columns is very easy and the modelling becomes quick.  In ETABS we cannot see the extruded view easily but in TSD we can see the extruded view easily. Basically, visualization is easy in TSD as compared to ETABS.   Step 2 In TSD load application is very easy as the dead load and live load both are almost same but in the wind...

What are TOF, SSL, & TOS in Tekla structural designer ?

  Tekla structural designer (TSD) is a simple, integrated design & analysis software that gives engineers the power to analyze and design buildings efficiently and profitably. Pile foundation as two parts likely pile cap and pile, here in TSD we can design the pile cap but not the pile. TOF (Top of foundation), TOS (Top of steel), SSL (Structural slab level) are the terms in TSD software which are used while creating levels. Refer the below steps we will know about TOF , SSL & TOS  : Step 1 Go to TSD software and click on construction levels, under that section you will come across the type of level being designed, likely TOF, TOS, & SSL.     TOF: Top of foundation is a level which is helpful for placing foundation, plinth level and helps in excavation work identification also. TOS: Top of steel (level) takes a major part while you are working with the steel structures, composite structures or else steel structure completely, so in these cases you can mak...

Difference Between Tekla Structures and Tekla Structural Designer

  NTRODUCTION: Tekla Structures and Tekla Structural Designer both are Software Developed by Trimble, some of the major differences between the two software are as Follows. 1. USAGE: The following are the primary differences between the two software based on their usage and the final product generated. TEKLA STRUCTURAL DESIGNER (TSD) is a  Structural Analysis & Design Software, it is used for structural analysis and design of all structural members after the application of loads (Eg. Live Load, Dead Load, Wind Load, Seismic Load etc.) as per the standard code provisions, varying with the location of construction of building. TEKLA STRUCTURES (TS) is a   Structural Detailing & Building Information Modelling (BIM) Software, it can be used for creating detailed model after we have the Structural design results. After finishing the BIM Model, a section can be cut from any Plane to generate Good For Construction Drawings (GEC) with detailing of rebar specifying the...