[Doug McLean]

Its challenging for sure. It also makes you think of a different way to do things.

One of the problems with going too far outside of the box though, is that others here are nowhere close to my level, so you have to also keep it in a way that others will understand.

If we do happen to win this project, knowing how to sort the Markup Summary will be crucial to the success.

Unfortunately with this project, I had to do my takeoffs on multiple layers of plans. There were mouldings on the ceilings that had to come off the RCP’s. There was sloped wainscoting on the stairs, along with sloped handrail. Window casing had to come off elevations, where the Crown and the picture rail came off plan view. I made sure that I used Spaces to name everything the same, so that when you have to sort the data later, its really easy to see what all is in what room. Otherwise, it would be a mess.

[Doug McLean]

There is another way….

You can make an area markup to the size of the island, and then do the math later.
Very easy in PQ. Not so easy to do within Revu itself (other than by copying the cutout)

[Doug McLean]

Its really only two tools, Area and Sequence.

An area tool will give you both the area and the perimeter (which is the length)
Then its just adding a textbox that will become the tool for the sequence.

Something I noticed what will show up in the measurement column will depend on where your cursor is when you group it. If its over the textbox, the Count will show up as the Measurement for the Group, but if its on the Area tool, the Area is the primary markup.

Something for everyone to remember.

[Doug McLean]

I’m going to second @Vince ‘s comment.

Create a custom line style. There’s an offset button to do exactly what you want.

Be careful though, the offset will be determined by which direction you make your markup.

[Doug McLean]

For those odd shapes you may want to try Dynamic Fill.

Can be a great tool when you get it working right.

[Doug McLean]

Sometimes it’s as easy as adding an extra control point.

[Doug McLean]

The final tally ;
33,115 lineal feet of various mouldings; Some of theses will be 3″ x 11″ when finished
11,764 square feet of paneled wainscoting
165 Custom Architectural Columns
14572 lineal feet of door casing with 420 Corbel’s and 59 Transoms
184 Custom Wood Doors and Frames
350 Separate pieces of Casework
32 Custom Millwork pieces including 3 large desks and 2 pulpits, and some custom trim with appliques.
Mirrors, Steel frames, Quartz countertops, subtops, and other miscellaneous parts

Final tally – Supply only – +/- $15,000,000.00 USD.

[Doug McLean]

So I just finished the Takeoff and ran a full mark-up summary.

3076 different line items.

Now bear in mind that I have a lot of these where I have two or three items taken off together (which I will have to separate in Power Query)

🤯🤯🤯

[Doug McLean]

A lot actually, especially when it comes to double takeoffs.

[Doug McLean]

Right?!?!

[Doug McLean]

nope, but this one will make your 🤯

[Doug McLean]

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

[Doug McLean]

fortunately, Power Query is also within Power BI, so if you do get the chance to learn even the basics in PQ, you’re moving in the right direction.

BI is really for visualizing your data. Excel CAN do this, but BI takes it up another level.

The big trick to learning either Power BI or Power Pivot (in Excel) is understanding what’s called the data model and the relationships between tables.

I’ll talk about that a little in my presentation in June

[Doug McLean]

Thanks Troy

Being a Journeyman, it comes with the gig. I know that teaching the next generation is part of that certification.
My instructors at BCIT taught us that its the best Journeymen that don’t let others repeat the same mistakes.

If I can help make your job easier, even once, then I’m happy.

[Doug McLean]

I personally love working off SharePoint. If you’re doing any kind of remote work its just so much faster than working over a VPN.
If you have a team working on a set of plans, I would suggest teaching people to access them through the DMS toolbar instead of File Explorer. This way, the file will get ‘checked out’ just like you’re working in a Studio Project. If you allow people to use File Explorer, you’ll get a local copy and you can actually have two people working on the same document at the same time.

Even if you have to pop into the field, all you need is an internet connection and you have your drawings. No need to log into your server remotely.