Merging Data in Schedules


AbakerKs
 Share

Recommended Posts

I'm working on trying to create some "custom" schedules but am having some trouble. With the wall schedule I've been asked to try and break it down a little different than what they have available in the standard wall schedule. They are wanting to be able to break down the lengths of walls by the plate height of rooms as well. So for example interior wall lengths at 9' as well as interior wall lengths at 10'.

 

Also I'm trying to find a way to get total length of casing and base entered into a schedule. I know how to find it in the material list breakout, but I was hoping there was a way I can tag it into a schedule somewhere (wall, window, or door probably). Any help would be much appreciated!!

Link to comment
Share on other sites

2 hours ago, AbakerKs said:

I'm working on trying to create some "custom" schedules but am having some trouble. With the wall schedule I've been asked to try and break it down a little different than what they have available in the standard wall schedule. They are wanting to be able to break down the lengths of walls by the plate height of rooms as well. So for example interior wall lengths at 9' as well as interior wall lengths at 10'.

 

Also I'm trying to find a way to get total length of casing and base entered into a schedule. I know how to find it in the material list breakout, but I was hoping there was a way I can tag it into a schedule somewhere (wall, window, or door probably). Any help would be much appreciated!!

I'm guessing that its not wall lengths you are after but rather wall heights as that would indicate a longer cut/stud length and would be more useful information. I'm not sure why you would want that in a schedule as opposed to a material list. What is the actual end goal, what are they trying to solve for?
Casing and base would be a custom schedule with custom macros. Would need to know more about the end goal again before I would advise on that. Seems as if you someone is tying to use this as a buy order. 

Link to comment
Share on other sites

20 hours ago, Renerabbitt said:

I'm guessing that its not wall lengths you are after but rather wall heights as that would indicate a longer cut/stud length and would be more useful information. I'm not sure why you would want that in a schedule as opposed to a material list. What is the actual end goal, what are they trying to solve for?
Casing and base would be a custom schedule with custom macros. Would need to know more about the end goal again before I would advise on that. Seems as if you someone is tying to use this as a buy order. 

So we are wanting to provide that information to help our salesman with takeoffs. Just as some extra information. So with the different plate heights you are right, I need the differing stud lengths but I still need the length of the wall so we can determine a stud count as well as a plate length. I started messing around with the materials lists to get the casing and base and that helped a lot. I DO prefer the presentation of the schedule though as opposed to the material reports. Plus with a schedule I can just send it straight to the layout and couldn't figure that out with the materials list. So at the end of the day if I can have lengths for the casing and base, my salesmen can run the manual takeoff to get a count on the number of pieces they should order. Same with the lengths of the walls per differing plate heights.

Link to comment
Share on other sites

3 hours ago, KaoSwung said:

If you have a parameter named "Plate Height" in your rooms, you can use a formula like IF(Room.Plate Height = 9' , [Wall Length], 0) in the "9' Walls" column. This will populate the length only if the room's plate height is 9 feet.

Can you elaborate on how this is accomplished?

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share