[Doug McLean]

Hi Jerome,

Unfortunately, Excel doesn’t natively handle base 12, so it won’t export in ft-in.

Others have suggested various workarounds but my suggestion would be to reformat the data in Power Query before it gets imported into your takeoff software. It would be quite easy to achieve and be very repeatable.

Is your software only capable of working in ft-in, or can it work in just inches?

[Doug McLean]

Don,

It sounds like what you really need is Power Query.

You can do quite a lot with one measurement, if it’s set up correctly

[Doug McLean]

One thing you’re really going to discover about Revu Mike, is that it is not designed with any of the finishing trades in mind. Typical, as we’re pretty much an afterthought anyways 🤣🤣
Those of us that have material size limitations all have the same frustrations with it. We’ve developed some interesting work arounds.

Fortunately, its quite customizable, so you can build tools that will suit your workflow.

[Doug McLean]

There is a centroid box you can check which will show the center of any markup. I believe it’s on the properties panel.

Are you asking how to make an irregular shape? Instead of click and hold, click and release, then click on your other points. You also may want to make sure your ‘Snap to Content’ box is selected.

[Doug McLean]

Wondering if anyone has any other insights on this?

This is actually going to be the topic of an upcoming video.
The way I deal with this is to get the data out of Revu and into something that will allow you to transform it.

[Doug McLean]

way to go Troy.

We might be getting a few more members here in the upcoming weeks. Just did an interview for a Podcast that I threw a few shameless plugs in for you.

[Doug McLean]

This is just another reason why I much prefer to work in individual sheets.

I never have to worry about going back to a previous view, I just pop to the other tab.
Where it becomes an issue is when I have a boatload of tabs open.

[Doug McLean]

What you COULD do, but you’d still need PQ, is export a PDF report. Then you can use Power Query to get the data from that report. I’m pretty sure that the PDF report will display in ft-in.

PQ will bring in the data as ft-in which you can then export to Excel. A quick save as a CSV file would be all that you need.

[Doug McLean]

this drives me batty.
Its also something that I drive into new users

[Doug McLean]

It is for this reason alone people like Vince and myself use Power Query.
The lack of a conditional formula option within Revu makes estimating for Millwork difficult.

Its kind of tricky to do everything so that the formula can be applied globally

[Doug McLean]

Hi Jeremey

There are already standard preset metric scales embedded in Revu, but, I’m not sure I trust them.
I almost always set my scales in metric to 1mm : 10mm etc. as I’m not really sure how Bluebeam set them up; are they 1cm:10cm? 1m:10m? I really don’t know.

[Doug McLean]

Its just learning a new skill.

[Doug McLean]

I also tend not to use the math functions in Revu because they are far to basic for my needs.

I’ll just export the data and do all that stuff in Excel. Much easier.

[Doug McLean]

The Round function works pretty much like the round function in Excel. I don’t think it rounds up or down though. It follows standard rules of rounding

[Doug McLean]

SQL is a Database reference. Might be the way the function works in there