[David Cutler]

Thank you for the tips @Doug McLean ! I figured it would be something simple – it usually is. Classic user error. 🤣

[David Cutler]

Thank you @Doug McLean !

One of my goals for 2025 is to figure this out! Thank you for getting me setup to succeed on this!😀

[David Cutler]

I think that I figured out my problem with being able to re-use my Power Query @Doug McLean !

The problem I found wasn’t in the “source” information (the information you provided previously on how to change the source location helped me with this). The problem was that I was deleting the output data table from my file! So basically I was successfully telling PQ where to find the data and what to do with it, but I had taken away the place that the query was setup to place the processed data. I had assumed that PQ would generate a new tab in the workbook when I selected “Close & Load” – since that is what it does when you first setup the Query.

So I now have a template file that includes the Power Query (with the output sheet) ready to go! Very excited to use this in the New Year!

Now, to work through the information you provided above to automate the process further… 😎

[David Cutler]

We may very well do that @Doug McLean – but we aren’t even at the point of having Revu available on their devices.

Curious to hear how folks are providing the interface for the folks in the field.

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

🙂

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

[David Cutler]

I find the way Dynamic Fill stops at the edge of the line very annoying in my workflows, but it may work for others? Perhaps it should be an option to have the fill run to the middle of the line?

[David Cutler]

I’ve built out a few sets of “contour” line types. I use these to highlight either the existing or proposed contours on grading plans to make the contour lines “pop”. They also work well if you want to copy the contour lines onto another view or sheet – say to take them from a grading plan back to an existing conditions plan.

I find that creating the custom linetypes is a bit clunky at best…

[David Cutler]

I’ve been using “0” on most of my area measurements lately as I’ve found I can be more “precise”. Not sure it has any impact on my overall price, but I feel like I’m being more accurate… 😎

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

[David Cutler]

You can set the scale of any toolchest. Simply click on the settings gear and then select “set scale”.

I have a few “scaled” toolchests based on the scales my drawings typically are set at. What is neat is if you have a markup that is say 10 feet long on a 1:20 scale sheet when you paste it to a 1:10 sheet it will automatically self adjust to the markup to the new scale.

This is really handy if you have a proposed condition drawing and 1 scale, and an existing condition drawing at another. You can take a snip of the proposed drawing, save it to a scaled toolchest and then apply the scaled snip markup to the existing condition drawing creating a scaled overlay. Bonus tip is to colorize the snip and set it to it’s own layer allowing you to clearly see the snip and toggle it on and off.

[David Cutler]

I see your “save to toolchest” for next time and raise you by suggesting saving it to a “scaled toolchest” so you can use the tool even if the scale is different. 🙂

[David Cutler]

@matt-hackman thought of your original question while using the “multiply” markup feature the yesterday. Thinking this might be a good way to equally space your sawcut lines across an area. You would still need to trim the ends if it is an odd shape, but it is a quick way to cast a series of markups across an area at an even spacing.

[David Cutler]

Just imported the custom columns into my standard items template. I then copied the new standard items page into my takeoff file and deleted the previous sheet. That did the trick! Now everything is in the correct columns!

What’s interesting in this exercise is that I’m pretty sure the standard items template file is the one that I exported the custom columns from in the first place… 🤣

Thank you for helping work through this one @troy-degroot and @Vince

[David Cutler]

Definitely interesting to see how this shakes out. Appears that I need to go back and import the custom columns into my cover sheet file to get them updated too…

I’ve gotten so comfortable using my existing tools that this is a bit frustrating.