Rebars count by lenght in Schedule

Rebars count by lenght in Schedule

REDO10
Collaborator Collaborator
4,805 Views
49 Replies
Message 1 of 50

Rebars count by lenght in Schedule

REDO10
Collaborator
Collaborator

Hi All,

Hi @ovidiu_paunescu 

 

In my project I want to count variable rebars's set these have a same number and length and group them in a single line in the schedule, as shown in the picture bellow

 

table_armatures.PNG

 

In my example bellow, I want put in schedule for rebars:

number 12:  (by element =10 ; elements = 1; Total elements = 10)

 number 13:  (by element =10 ; elements = 1; Total elements = 10)

 

rebars_schedule.PNG

 

How can I do that? 

 

Thanks.

 

0 Likes
4,806 Views
49 Replies
Replies (49)
Message 2 of 50

L.Maas
Mentor
Mentor

What you want to do is use grouping (on the grouping and sorting tab of the schedule).

And if you want summation of the grouped elements, on the formatting tab you can set calculate totals for each of the fields you want to have summed up.

See THIS site with some explanations how to set things up

 

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

Message 3 of 50

REDO10
Collaborator
Collaborator

finally, I managed to group the variable rebars having the same length and the same number in a single line by unchecking Itemize every instance but I still have problem to calculate the total rebars count for each of them

see image bellow:

 

table_armatures_modifiée.PNG

 

for exemple: N° 16 : Total count is: 6 x 4 =24 and that is correct

but for N° 17: count should be 1 x 15 = 15 not 225!!!??? 

 

how to solve that?

Thanks.

0 Likes
Message 4 of 50

REDO10
Collaborator
Collaborator

Hi,

@ovidiu_paunescu@semi , @ToanDN 

 

Decidedly it'll take me extra time to finish this schedule!! ‌‌

I don't understand how REVIT calculates the total count of rebars with variable lengths in the same set!!!... I noticed that REVIT uses a square function to calculate the count of  these rebars and that is wrong!!

All counts of my rebars having variable lengths are false!! (see schedule bellow)

 

schedule.PNG

for example in the image bellow , the count of rebar N°17 should be 15 not 225!!! ( Note: L = 64.45m is the sum lengths of 15 rebars)

rebar_17.PNG

 

please check the portion of my attached file bellow to find a solution to my problem

 

Thanks

0 Likes
Message 5 of 50

ToanDN
Consultant
Consultant

Format > Quantity of Rebar Set > No Calculation

Message 6 of 50

semi
Collaborator
Collaborator

Beware that you shouldn't calculate every parameter's totals.

These are my settings:

semi_0-1652768891036.png

 

semi_1-1652768915614.png

semi_2-1652768929221.pngsemi_3-1652768941614.pngsemi_4-1652768960684.png

Result:

semi_5-1652769218337.png

 

 

0 Likes
Message 7 of 50

REDO10
Collaborator
Collaborator

@semi 

@ovidiu_paunescu 

 

I made some change in my parameters according your example, so check them please in images bellow and tell me if I'm correct....I still have some questions

 

table1.PNG

 

quantity by rebars set.PNGby element count.PNGTotal count.PNGTotal weight.PNG

 

01- Why I can't display set's sum variable lengths for N°17,18,19 and 20 as I mentioned in the schedule above??...should I add separate row for that and use a formula to calculate their sum? ...and then how can I group them with the others in the same row "rebars length"?

 

02- in addition why I can't display their weight??

 

03- I noticed that REVIT dont calculate different values correctly and this is due probably to the definition of the number of digits after the comma (I used 3 digits for all parameters)....for example: 

N° 50:  total length = 740 x 7.601 (should be equal to : 5624,740 m and REVIT give: 5624,600 m)

             total weight = 5624,740 x 1.208 (should be equal to : 6794,686 kg and REVIT give: 6796,843 kg)

how to fix that?

 

Thanks.

0 Likes
Message 8 of 50

semi
Collaborator
Collaborator

-01 what parameter drives your rebar "length"? Is it defined by a segment "A" or any other letter? 

semi_3-1652906387920.png

When using a varying set u have 2 options:

in a group = all rebars same number but ranging from this height to that height

semi_4-1652906719378.png

semi_9-1652907350002.png

 

 

seperately = all rebars different number:

 

semi_5-1652906994717.png

result:

bars as a hole (grouped):

I do need to itemize every instance now else I get a "variable length" which is logical

 

semi_8-1652907267315.png

 

 

seperately

semi_7-1652907156691.png

 

 

-02: simply because the weight is calculated by the rebar length, so no length means no weight

-03: probably because you haven't set the correct rounding under reinforcement settings and units:

semi_0-1652905922889.png

 

semi_1-1652905989783.png

 

Message 9 of 50

REDO10
Collaborator
Collaborator

@semi wrote:

-01 what parameter drives your rebar "length"? Is it defined by a segment "A" or any other letter? 

 


yes, parameter that drive my rebar length is "A" , see example bellow:

 

rebar 17.PNG

 


@semi wrote:

When using a varying set u have 2 options:

in a group = all rebars same number but ranging from this height to that height

 

seperately = all rebars different number:

 


I know that are two options to define position of variable rebars in the set, and for me I chosen to number them as a whole to avoid over numbering in the schedule.

 

What I wanted to say is that it is possible to calculate the average length of the variable bars in the set to display it in the schedule using for this purpose a bar parameter as you have quoted and which is the parameter "A" for example?

in short I want my schedule to be established as that of Autocad structural detailing (ASD), see the image below

 

ASD.PNG

 


@semi wrote:

 

-03: probably because you haven't set the correct rounding under reinforcement settings and units:

 


My reinforcement settings and units are same as your example and I still have error of rounding!!!

 

Thanks.

0 Likes
Message 10 of 50

semi
Collaborator
Collaborator

What are you rebar length settings?

semi_1-1653028095958.png

 

For rebars grouped as a hole but with the same rebar number I use the minimum and maximum totals:

 

semi_2-1653028195892.png

semi_3-1653028227983.png

 

This determines the range of the rebar lengths.

 

Right now as I see it your grouped rebars are scheduled as a hole (not itemized per unit) so Revit now tries to show one rebar for a different set of grouped rebars who all have a different "a" length parameter which causes your schedule to not show a length which is logical because they are all different.

 

Message 11 of 50

REDO10
Collaborator
Collaborator

@ovidiu_paunescu 

 

I tagged you many time and no reply from you!?
have you any contribution or idea to solve my issue?

Thanks.

0 Likes
Message 12 of 50

REDO10
Collaborator
Collaborator

@semi 

 

Bellow you find my rebars settings:

 

for length:

 

rebar settings.PNG

and for mass:

 

masse setting.PNG

 


@semi wrote:

Right now as I see it your grouped rebars are scheduled as a hole (not itemized per unit) so Revit now tries to show one rebar for a different set of grouped rebars who all have a different "a" length parameter which causes your schedule to not show a length which is logical because they are all different.

 


So, no possibility to add parameter to calculate an average length?

 

Thanks.

0 Likes
Message 13 of 50

semi
Collaborator
Collaborator

See it from the contractors perspective: how is a contractor supposed to know the exact length of a group of rebars if he only has an average length? If you show him min. and max. length he knows the range needed. Then he has 2 options: make the same length rebar matching the maximum length needed and cutting off the rebars at site or evenly match out the rebars, but the latter would take too much time.
Try fix your rebars so they end up ungrouped. This should fix your BBS.

Message 14 of 50

ovidiu_paunescu
Autodesk
Autodesk

Hi @REDO10 

 

Count is a schedule field that counts the number of elements. You shouldn't use count for rebar as the bars inside a varying set are sub-elements.

For this you can use quantity which is equal to 1. If you want to show the entire quantity of bars in a varying or uniform set, you can use quantity by rebar set.

 

If you are numbering the varying set individually (each bar gets a rebar number), the regular sorting and grouping would work.

 

So you can add the following fields:

  • Rebar Number
  • Quantity
  • Bar Length

Then you need to:

  • Sort by Rebar Number
  • Uncheck itemize
  • Set quantity to Calculate totals
  • Set Bar Length to calculate totals
  • Add mass / m and compute the weight of each group of bars

RebarSchedule.png



Ovidiu Paunescu, M.Sc. Str. Eng.

Sr. Product Owner | Autodesk Revit

Message 15 of 50

REDO10
Collaborator
Collaborator

@semi 

 

I know that it is necessary to provide the contractors with the complete details of the reinforcement and precisely I will make a separate schedule for rebars with variable lengths in sets to indicate their details

 

When I talked about the average length of the variable rebars it’s just for a display aspect in the schedule...I don’t want to leave the fields empty that’s why I want that my schedule to be according to that of Autacad Structural Detailing (ASD)...too bad!!

 

Thanks.

0 Likes
Message 16 of 50

REDO10
Collaborator
Collaborator

As I said before it won’t be easy for me to finish this schedule!!!... I have another issue!!

 

In fact, as my tank is circular and my main reinforcement is radial, and precisely for the tank's dome I am obliged to interpose the positions of my sets's variable rebars to keep a minimum spacing between them and avoid their overlap in dome's head ...then for the example of the rebars N°64 I defined a spacing of (5cm) at the dome's head to obtain the necessary spacing of 2.00m at the base. to this end REVIT displays a spacing of 5cm in rebar's tag and schedule that must be 2.00m..the reason why I entered the real spacing wich is (2.00m) in the comment field under rebar's properties tab to be able to display it in rebars tag. see image bellow

 

rebar 63.PNG

dome schedule.PNG

 

my problem now I want to merge between spacing field and comment field in schedule to create a new field that displays my real spacing, so I thought of using a conditional statement formula and I entered the follwing formula syntax: IF(spacing<5cm, comments, spacing) ...but REVIT tell me there are incompatible units!!

 

any Idea to resolve this problem?

 

Thanks.

0 Likes
Message 17 of 50

ToanDN
Consultant
Consultant

You can not mix a text parameter (Comments) and a Length parameter (Spacing) in one formula.  Create another Length parameter for Rebars category, and use it in the formula instead of Comments.

Message 18 of 50

REDO10
Collaborator
Collaborator

Hi @ToanDN 

 

Can you show me how to do that pls?

I tried to edit the rebars type but I couldn’t do it

Thanks.

 

 

0 Likes
Message 19 of 50

semi
Collaborator
Collaborator

Giving a spacing to a circular rebar setup doesn't make sense. Just setting up your plan with the dimensions would suffice in my opinion. We also never set spacing in a schedule (is that necessary?) I would just write a text with that rebar tag saying spacing = 2m at the ends and place the dimenions around your tank reinforcements.
A contractor will notice this and it will all be clear to him.

Message 20 of 50

ToanDN
Consultant
Consultant

@REDO10 wrote:

Hi @ToanDN 

 

Can you show me how to do that pls?

I tried to edit the rebars type but I couldn’t do it

Thanks.

 

 


ToanDN_0-1653324975083.png