[Doug McLean]

Welcome to the Brainery.

Care to share a little more info on what you do and how you’re using Revu?

[Doug McLean]

Chances are, someone else has opened it previously and their custom columns are already with the PDF.

To save yourself some effort, you can set up a quick macro to import your custom columns. (If you have Extreme/ Complete)

[Doug McLean]

You will need a second area markup, but you won’t need another Column.

You could do a second custom column, ‘material 1’ ‘material 2’ but I’m not too sure how any value associated with the material would play out in that scenario.

Run an experiment

[Doug McLean]

I just checked this and it worked out fine.
I set a Material 1 and a Material 2 Custom Column and gave them each a value.
Then I build a total column with the formula (Measurement*Material 1)+(Measurement*Material 2)

To save yourself some headaches, I would put your materials and their cost into a csv file for easy import.

[Doug McLean]

I did eventually find something and you can’t. If you open it via a hyperlink, it will always open in the browser

[Doug McLean]

Hey Nic, all great questions.

#1 yes. Click on the end node to select the tool, Rt. Click (right click is your very best friend btw) and then click Resume.

#2 Try applying your custom columns first. If that doesn’t work, check your tools to see if they have built in layers

#3 You can change the column layout (pretty much works like Excel in dragging columns) and you can change the sort order, but that’s about it. You can also set custom filters if that works for you

#4 Open the Legend Properties. You can do all of that there.

#5 in a word no…but… you can apply the same scale to multiple pages at the same time.
I have a trick for this to select them quickly. It should be under the Tips and Tricks forum.

Hopefully I helped a little

[Doug McLean]

the real key to using Power Query is a consistent output of data.

Take the time to learn how to set up a proper BatchConfig output file with exactly what you want.
I talked about planning properly in my presentation, because that is the very first thing you need to do. Figure out what you want to do, figure out where you are, then figure out how to get there.

I have one slide in my presentation that says how data without context is just noise. We can generate so much data now in construction that we have to learn how to filter out all of the noise and get to what we really want.

[Doug McLean]

I put it up on our TV in the Estimating office and had my team watch it.

More than one note was taken. Even by me.

Liz mentions this herself, if she can teach even an advanced user something, she’s done well.

[Doug McLean]

I’ve mentioned before that there are some issues with working with Sets on the cloud (in both SharePoint and Studio) but the solution is almost too simple. I’m actually a little ticked at myself for not thinking of doing this sooner because I actually USE this workflow at times.

Sets allows you to create a drawing log really easily. Once the Set is created, simply make that and then pin the log to your file access panel. That’s it. Incredibly simple right? You can just use the drawing index page, if there is one, but a full log does have the potential to be more useful if you want to see revisions easier.

When you go to load a Set from the DMS toolbar, it takes quite a while, and I’ve noticed that the files don’t automatically try to ‘check out’ when opened from a hyperlink. If I do this from the drawing log… they ‘check out’ themselves. Plus you’re not opening the whole set, you’re really only opening the drawing log.

SharePoint doesn’t recognize the .bet file that Revu creates for a Set, so you can’t open it directly from SharePoint, like you can with a regular PDF. The drawing log is a regular pdf file, so it opens.

I’m kicking myself for not thinking of this earlier.

[Doug McLean]

keep learning David, you’ll get there

[Doug McLean]

its pretty easy to send feedback… Help> Make a Suggestion, it will do the rest.

Several of us have made suggestions, on various things. One of the few I’ve suggested actually came to fruition, which was the ability to set scales to multiple pages at the same time. We’ve only been able to do this since Revu19.

You’ll find macro’s in Revu MUCH easier to do than than Excel. You don’t need to learn VBA for one. They’re much simpler.

I wholeheartedly agree that something as simple as your custom columns could be a quick popup box, but setting up a quick macro and making it part of your workflow is actually quite simple. Bluebeam likes to say that they support Estimators, but honestly, they focus more of their support towards field ops and collaboration with Architects, Engineers and GC’s IMO.

[Doug McLean]

Firstly, you have to have Extreme/ Complete

Then you need to have this document https://support.bluebeam.com/wp-content/uploads/2019/08/Bluebeam-Script-Reference-2018.pdf

Now go to the Help menu for Using Scripts in Revu… it will walk you through everything you’ll need to know (there’s even a link the Script Reference I posted above)

Good luck

[Doug McLean]

Maybe think about adding the Status column.

I know you’re new, but you should learn about this wonderful column and what it can do.

If your Estimating team is making the markups, then build your Custom Status to default to “Estimator Review”. Then the PM can update the status later to “PM Review”.

You’ll also be able to sort by Status in the markups list

[Doug McLean]

I was also thinking maybe multiple legends might be a solution.

[Doug McLean]

NIc

Power Query will allow you to take your data, and then reconfigure it just about any way you want it. It’s really nothing more than a series of pre defined steps to wash the data.

If you want the guru’s, check out guys like Mike Girvin @Excelisfun or Leila Gharani @XelPlus on YouTube. These guys will get you started. There are many others out there as well.

As Troy mentioned, I’m doing my XCON presentation in June, so make sure you register for it. I’ll be doing some of it live, so you’ll get to see it in action.