Forum Replies Created

Page 8 of 26
  • Doug McLean

    Member
    September 19, 2023 at 3:22 pm in reply to: Numbers before Sheet #
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    That’s the way whoever created the PDF’s chose to label them.

    Quickly fixed with page labeling

  • Doug McLean

    Member
    September 19, 2023 at 3:16 pm in reply to: Excel and Quantity Link Script
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    Well at least someone else has found my frustration with Quantity Link when doing something for the finishing trades.
    We can’t set up and use a template, so it becomes VERY time consuming to set up.

    As others have said, export the data to a csv file and then use probably Excel’s most powerful tool, Power Query to do the heavy lifting. It’ll take you a while to learn it, but once you get it, its amazing.

    Both Vince and myself have some pretty cool workflows using PQ, so if you need some help, just ask.

  • Doug McLean

    Member
    September 2, 2023 at 11:56 am in reply to: Most random use of the Markups list.
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    I once used it to unsubscribe from an email list.

    For some reason our Estimating email got on this email list that was all in Russian. I couldn’t read it to figure out how to unsubscribe. I eventually had a lightbulb moment.

    I made a PDF out of the email, then used a highlighter and the Translate Markups function to figure out where the Unsubscribe link was.

    Worked like a charm.

  • Doug McLean

    Member
    August 29, 2023 at 8:13 pm in reply to: Bluebeam use with Excel and Fabsuite
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    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

    Member
    August 25, 2023 at 10:35 pm in reply to: Spaces for Individual Rooms
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    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

    Member
    August 21, 2023 at 1:24 pm in reply to: Mid-Point Slide
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    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

    Member
    September 19, 2023 at 3:20 pm in reply to: Excel and Quantity Link Script
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    finally diving in eh David?

  • Doug McLean

    Member
    September 19, 2023 at 3:17 pm in reply to: Excel and Quantity Link Script
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    There isn’t a PA connector to Revu

  • Doug McLean

    Member
    September 2, 2023 at 11:52 am in reply to: Most random use of the Markups list.
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    by the way…. this is brilliant.
    I never would have thought of doing that. EVER.

  • Doug McLean

    Member
    August 30, 2023 at 9:27 pm in reply to: Bluebeam use with Excel and Fabsuite
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    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

    Member
    August 28, 2023 at 1:51 pm in reply to: Custom Column Examples?
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

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

  • Doug McLean

    Member
    August 28, 2023 at 1:49 pm in reply to: Custom Column Examples?
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    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

    Member
    August 28, 2023 at 1:41 pm in reply to: Metric Scales
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    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

    Member
    August 27, 2023 at 11:19 am in reply to: Spaces for Individual Rooms
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    Its just learning a new skill.

  • Doug McLean

    Member
    August 21, 2023 at 11:19 am in reply to: Mid-Point Slide
    Points: 12,630
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    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.

Page 8 of 26