[Vince]

Create the markup to the required size and then put a text box in it with just a “1” in the box. Then group together and save to your toolbox. Finally, create a sequence from there?

[Vince]

You can fix this in custom line styles and you can probably make a much better markup by including some text as well.

Below is a line style I created for measuring the masonry in foundations: –

[Vince]

So how much of the new stuff that you’ve learned will be used on your normal boring everyday take-offs???

[Vince]

In a word “No”

[Vince]

The way in which the webinar was described made me think it was going to be a lot more in depth than it was.

Like you, I thought things were touched on but never explained in any sort of detail whatsoever.

However, the Power BI section did make me question whether this was a resource that I needed to look at, so I guess that was good. This is also partly because I believe that BI can be faster than PQ which is something that I desperately need as my calculations seem to be overloading PQ.

In the end though, I’ve decided that for my workflows I need to stick to Excel with Power Query as Excel is where I need to place all of the results for further usage.

[Vince]

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!

[Vince]

Once the markups are grouped then the text in the comments column doesn’t export unless everything is ungrouped again.

[Vince]

As an extra note on this, if you set up a line style like shown in my picture you can get it to work easily in different scaled drawings e.g. the above was set up to work on a 1:50 scale drawing using a line thickness of 3.

If you are working on a 1:100 or 1:200 drawing all you need to do is reduce the thickness to say 1.50.

So, just adjust the line thicknesses of your tools in the actual toolboxes before you start marking up and that’s it.

[Vince]

That’s a very big ‘if’ if you are here in the UK!

[Vince]

That sounds great @Doug ! I’m assuming there is a bit of “unpivoting other columns” going on in there now?

[Vince]

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.

[Vince]

@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.

[Vince]

How about a custom line that looks like the panelling (top and bottom rails, etc.) when the markup is applied to the drawings??? 🤣

[Vince]

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.

[Vince]

It definitely works – one measurement in Revu is then applied to multiple items in Excel.