[Vince]

Great presentation @Doug and thanks for the shout out!

As you said, we are all getting ideas and learning from each other.

I’ll certainly being logging back into your studio project as I want to see if I can use a couple of those power query details in some of what I do!

[Vince]

Very useful especially when the base drawing seems to have a layer for every single drawn line!

[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]

Let’s hope this update doesn’t take as long as the one which corrected the disappearing layer issue!

[Vince]

@David – I was looking for a way to merge the existing layers into smaller groups e.g. once of the drawings I have has about a dozen layers for each of these boundary treatments, pumping station compound, etc..

Unfortunately, I couldn’t seem to get this to work.

Does anyone else know if this is possible?

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