Estimating
Public Group
Public Group
Active a day ago
Estimating could include material take-offs for simple quantities or complex pricing. Whether you... View more
Public Group
Wainscoting Takeoff
-
Wainscoting Takeoff
Posted by Doug McLean on May 1, 2023 at 3:28 pmCurious as to how the best way to go about doing this takeoff.
There is a LOT of this wainscot, and as you can tell from the section, its got a bunch of parts.
Doug McLean replied 1 year, 6 months ago 4 Members · 23 Replies -
23 Replies
-
Points: 13,606Rank: UC2 Brainery Blue Belt III
I’m not sure how much detail you need to show on your marked up drawings but from my perspective this is ideal for power query.
Assuming the detail remains consistent, one linear measurement on you plan(s) is all you need then the component details can be in a table in Excel.
I’m assuming that there aren’t any stiles because of how the upper and lower rails sit in relation to the actual panel? However, even if there are, then once again this can be added in in the PQ stage.
The linear measurement is also probably better for the main panel as there is that lovely detail again where the height is just over half a sheet of board creating loads of waste!
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
hmmm…. that could work
-
Points: 13,606Rank: UC2 Brainery Blue Belt III
It definitely works – one measurement in Revu is then applied to multiple items in Excel.
-
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
That is definitely something to think about and you’ve got my brain working on it.
This job is a HUGE LDS temple and has a lot of repeating parts and good schedules.
We’re also in line to be bidding 4-6 of these a year, so anything we can do to speed up the process would be awesome
-
-
Points: 26,509Rank: UC2 Brainery Advanced Brown Belt
I like the idea of one linear measurement being used to capture all of the materials. Could you use Spaces to identify the individual rooms and some sort of lookup extracted from the schedule tables to determine what detail should be followed for each space?
Could you give us a snip of a plan view so that we have a better idea of the “big picture”?
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
Vince has my brain working overtime on this one.
I could so use this on all the crown, wainscoting, door trims…. a lot of things. Save the other markups for casework or other things.
This is a typical elevation. Like I said earlier, there is a good finish schedule (which I could export) and then add a couple of columns too (i.e. crown type). Then I could definitely do some wizardry with PQ on things. Spaces are a must.Hell, I could even kill two birds with one stone and use Dynamic Fill to do a Space and an Perimeter measurement at the same time
Damn you Vince!!!!… 🤣🤣🤯🤣🤣
-
Points: 13,606Rank: UC2 Brainery Blue Belt III
Sorry @Doug! 🤣
In all seriousness, adding the details in PQ is really simple. You could use that for the doors too – just do a count and then in Excel you can have everything down to the hinges, latches, etc..
And the breakdowns can all automatically work with spaces.
Give me a shout if you want to run through anything.
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
I did this with the door casings and whatnot.
Unfortunately, it took me longer to format the data than it did to do the math. Learned a whole bunch along the way though.Next up, the wainscoting and all the trim
-
Points: 13,606Rank: UC2 Brainery Blue Belt III
@Doug I’m not sure how you normally detail all of this in Revu but is it possible to do something like: –
1. In the subject column (or whichever column contains the details) enter the details as follows “Wainscott; Top Rail; Bottom Rail; Panel;” etc in the format that you want.
2. Then in PQ just split the column on every “; “
I’ve done something similar to this on my drainage workflow.
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
Insert your own delimiter… that works.
What I meant earlier was about the import of the door schedule. The data was a mess and I probably should have just fixed it in the csv file. A bunch of the columns were offset and I needed to get them all lined up in the right ones.
Once I had that, the rest took me less than 30 minutes
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
@Vince … I’ve kicked this one up to a 12
Doing this made me learn a few things. I made a few tools using the ; as a delimiter for the Label, then I got to thinking… could I do this for both the Label AND the Subject. Turns out I can.
I had to learn a couple of new tricks in Power Query, but HOLY COW!!!!.It even works if I have a different number of delimiters.
Me thinks a video is coming on how this is done.
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
nope, but this one will make your 🤯
-
-
Points: 26,509Rank: UC2 Brainery Advanced Brown Belt
That’s part of fun @Doug McLean – learning/figuring it out now and then applying it right out of the gate in the future. 😎
-
-
-
-
-
Points: 23,573Rank: UC2 Brainery Brown Belt III
You guys are all awesome, I love reading through the brainstorming process. Whatever answer I would give would not involve PQ, so it feels so basic. 🤣
I think a linear measurement will capture all the horizontal material, and a formula maybe combined with Wall Area would get all the panels and vertical materials.
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
We can also get multiple takeoffs from the one markup.
In most of these rooms, I can get both the crown and the wainscoting from a single markup. (normally I would also get the base, but it’s all stone).
-
Points: 23,573Rank: UC2 Brainery Brown Belt III
Thats what I was thinking, there were about six different trim pieces running horizontally in that detail.
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
It doesn’t really show in section well, but one of those is a panel molding that is about 6′ around each opening.
The LDS church really LOVES this level of finish in their temples. The trick is finding the right installation crew to handle the really high end finish.
-
-
Points: 26,509Rank: UC2 Brainery Advanced Brown Belt
If you used a single linear measurement of the room perimeter would you need to deduct for doors, or is that just considered waste on the wainscoting?
You could also add crown for over the doors based on a door count, but that might cause you to show needing multiple short lengths were your field crews would rather have single long pieces…
That brings another question – for figuring waste do you need the length of each wall individually, or can you work with one measurement for each space? Getting way into the weeds here!
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
fortunately all the ceilings here are at 12′ or better, so the crown goes over the top of everything.
As for the doors in the wainscoting, I made a count tool for the different size doors which I will deduct out of the perimeter.-
Points: 13,606Rank: UC2 Brainery Blue Belt III
If you measured each wall individually then you could automatically work out how many stiles you needed based on maximum centres being used. This is similar to what I did with the posts in my fencing example. This works especially well if you’ve got some short return walls or something like that.
-
-
-
-
Points: 13,606Rank: UC2 Brainery Blue Belt III
How about a custom line that looks like the panelling (top and bottom rails, etc.) when the markup is applied to the drawings??? 🤣
-
Points: 14,962Rank: UC2 Brainery Blue Belt IIII
I don’t want to get that crazy… lol 🤣
-
-
Log in to reply.