walls types schedule summary formula

walls types schedule summary formula

BIM_Dreamer
Collaborator Collaborator
2,366 Views
10 Replies
Message 1 of 11

walls types schedule summary formula

BIM_Dreamer
Collaborator
Collaborator

i have 5 storey model with different types of walls. how to create a wall types summary of total length every floor in wall schedule. for example i have 300 thk rc wall, 100mm thk alc wall in every floor so i want to show them combine total length each type of wall of every floor.  and how to create formula. thank you

0 Likes
Accepted solutions (1)
2,367 Views
10 Replies
Replies (10)
Message 2 of 11

BIM_Dreamer
Collaborator
Collaborator

something like this, any suggestion. thank you

 

CAD1.JPG

0 Likes
Message 3 of 11

constantin.stroescu
Mentor
Mentor

You mean something like this:

Image 1.png

Constantin Stroescu

EESignature

0 Likes
Message 4 of 11

BIM_Dreamer
Collaborator
Collaborator

thank you for your reply, i have already that one, i need a combined wall types with total length in schedule, something like this. thank you

CAD1.JPG

 

0 Likes
Message 5 of 11

BIM_Dreamer
Collaborator
Collaborator

something like this in wall schedule. thanks you

 

com.JPG

0 Likes
Message 6 of 11

constantin.stroescu
Mentor
Mentor

Then, like this:

Image 2.png

Constantin Stroescu

EESignature

Message 7 of 11

BIM_Dreamer
Collaborator
Collaborator

Yes that's the one please show me how you did this. Thanks

0 Likes
Message 8 of 11

constantin.stroescu
Mentor
Mentor
  • Fields : I used the Family and Type field in order to place Type Marks to wall in a quick mode...Later this Field is hide..

 

Image 1.png

 

  • I use Filter in order to isolate a Level..

Image 2.png

 

  • and then Sorting/Grouping - Sort by Type Mark and Base Constraint ( the Level on which the wall is placed) . No Grand Total , No Itemize Instance

Image 3.png

 

 

  • Formating:  
    • as said before the Field Family and Type was used only for a quick selection, that's why I'll check it as Hidden Field (not to be shown)

Image 4.png

 

  • Base Constraint - I can change the name into LEVEL

Image 5.png

 

  • Type Mark needs no other settings

 

  • Length Field
    • check Calculate Totals

Image 6.png

 

  • you can also change the Units here

Image 7.png

 

Constantin Stroescu

EESignature

Message 9 of 11

BIM_Dreamer
Collaborator
Collaborator

Sorry just realise your sample is not what I want. For example in level 1 you have W200 and the length is 14.55 and you have three same types in level 1 so the total length is 43.65. So I want to show like this in wall schedule W200 TOTAL LENGTH 43.65. I hope you understand what im trying to achieve. Thank you

0 Likes
Message 11 of 11

constantin.stroescu
Mentor
Mentor
Accepted solution

 

Constantin Stroescu

EESignature