[Vince]

As the end destination for my workflows is an Excel spreadsheet all I need to do is hit the refresh button before I make my final submission.

Maybe you could use the Date column in Revu and a date box in Excel as part of your final check?

[Doug McLean]

you need to set up a macro to refresh on open

[Vince]

I don’t always want to update upon opening the spreadsheet hence choosing when to refresh. Sometimes I like to save a new copy so I have a version history or so I can play around with the info that has already been collected.

That’s not to say that I don’t have macros that run on opening or closing a spreadsheet. I have ones that close and hide all the worksheets when closing. Then on opening the sheets only unhide if the user has the correct credentials – machine name or something like that.

[Doug McLean]

Mine starts early on.

I start by making my Spaces on the floor plans and placing a custom tool that we use for any given Millwork Callout. (We’ve also recently updated this process to include items that we can’t run though our estimating software)

Then I make the corresponding Space markups on the elevation drawings. We name the Space the same as the Millwork Callout so that its easy to tie everything together later.

Next we use a collection of Custom tools designed to work with our estimating software to do all the takeoffs, then its just a matter of running through the process.

The best thing you can do to keep up on your QC is be vigilant. Always make sure that tools are up to date. BatchConfig files are correct, any data tables are current, etc.
Keeping your team up to date too is also very important.

[Troy DeGroot]

@Doug McLean do you ever Edit Action on the symbol and create a hyperlink to the space on the other sheet? You could do one in each view to reference back & forth making navigation quicker….. Maybe, just a thought. 🤣

[Doug McLean]

I’ve tried that, its tricky and time consuming to set up.

I wish the Hyperlink abilities of Spaces were better.

[Troy DeGroot]

I assume Places would be just as tricky?

[David Cutler]

“Places” @troy-degroot ?

Are you referring to a location on a drawing, or is this a feature of Revu that I don’t know about????

[Doug McLean]

@DavidCutler
Places can be found on the Links Panel.
They are similar to a Space, but slightly different.
A Place would be something that multiple things can be linked too, like a section detail.

[David Cutler]

And yet again you I’ve found out about a feature that I didn’t know I didn’t know about. Not sure how I’d apply it yet, but something to file away in the back of my mind for future applications…

🙂

[Doug McLean]

@troy-degroot
they are.
Far too manual for my liking

[Troy DeGroot]

I figured.

[Doug McLean]

I also hope you’re moving forward with PQ. There’s so much too it.

I’m going to try and do a couple of cool videos over my Christmas break to show some really cool tricks I just learned. (Just have to practice a bit first 😉)

[David Cutler]

I’m using PQ to wash my data, but need to firm up my processes so that I can re-use the query, instead of re-writing it each time. I’ve played with updating the data source location, but don’t have that dialed in quite yet. I know you’ve said that that process is addressed in your Excon presentation, but I haven’t gone back to dig into it yet…

[Doug McLean]

Reusing a Query is one of its biggest advantages. You’re going to need to do a little bit of coding to make it work, but its pretty easy stuff.
Maybe I’ll add that to the list 🤔 😁