Forum Replies Created

Page 27 of 31
  • Doug McLean

    Member
    June 21, 2022 at 2:03 pm in reply to: Set Tags to Markups List
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I might have found something.
    There is a setting to automatically save a Set drawing log when saving a set, which saves it to the same location as the .bex file is saved.
    I should be able to just use that as I can use Power Query to grab that file

  • Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    You’ll probably have to update the link in this case.
    left click on markup to select > rt. click > Edit Action

  • Doug McLean

    Member
    June 14, 2022 at 1:30 pm in reply to: Linear Footage of Saw Cutting
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    wouldn’t the formula be something like – ((number of 2 x 2 blocks * 4) + width + height)
    Assuming each 2 x 2 square will be cut on at least one width and one height and the attached 2 x 2 square will complete the cut. Then the additional width and height will complete all the cuts.

  • Doug McLean

    Member
    May 25, 2022 at 9:05 pm in reply to: Where did I put that custom tool?
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    David, you might try this.

    I have a few custom tool chests that are a little generic. Each only holds a few tools. What I have is a custom column called Product that holds the different types of what is represented in the tool chest. For example, in my Casework – Wall tool chest there are only about 6 tools, but once I place that, I have about 20 specific Products associated with that markup.
    In my Custom Column data, I have the various products set to specific subjects, so only those products associated with a specific subject appear in the dropdown list.

    Would something like that help you out at all?
    I know its not exactly what you’re looking for, but it does make finding stuff easier.

  • Doug McLean

    Member
    April 4, 2022 at 4:34 pm in reply to: Combine several pdfs into one
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I’ve used this in the past as well. Its a great trick… one that can confuse the average user

  • Doug McLean

    Member
    April 4, 2022 at 9:36 am in reply to: Example of Using Bluebeam and Power Query
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    Here are two files that show how it all done. If you want to run the test, they’ll need to be placed in the same folder (as that’s how the PQ is written). This is a pretty small data set, but the speed for a larger one isn’t much different.
    If you want to see the steps in the Query, click on the Data tab and then hit Queries and Connections. This will open a list of the left.
    The sheet also has two macros that will break the Space column down into Tabs, and another one which saves the tabs a individual csv files so that we can upload those to our Estimating Software.

    Any questions, please don’t hesitate to ask.

  • Doug McLean

    Member
    April 3, 2022 at 12:42 pm in reply to: Example of Using Bluebeam and Power Query
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I can send anyone links to places on YouTube to learn PQ if they want.

  • Doug McLean

    Member
    April 1, 2022 at 2:53 pm in reply to: Exporting Data to other programs
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    Thanks to a tip from Vince, I just updated this entire workflow.
    I took a bunch of the common Options and broke them down into individual Custom Columns. So now I essentially have a dropdown list for all of my common options.

    Of course I have to completely re-write the Power Query to stich everything back together, but that’s the fun part.

    Along the way I’ve learned how to do a couple of really cool things with PQ, like Find/ Replace from an existing table (which is pretty cool btw).

    The whole process took about 3 days, and I’m now testing it out in the world.
    I’ll keep you posted

  • Doug McLean

    Member
    June 16, 2022 at 10:42 am in reply to: XCON Presenter Package
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I heard back from Bluebeam.
    They’re hoping for the end of the week. Still waiting on final approval.

  • Doug McLean

    Member
    June 16, 2022 at 8:10 am in reply to: XCON Presenter Package
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I dropped an email to Bluebeam this morning.
    I don’t want to get too far ahead in my PPT design and then have to fit their template

  • Doug McLean

    Member
    April 25, 2022 at 8:54 am in reply to: Studio Prime
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I figured it out. You double pasted the link.

  • Doug McLean

    Member
    April 24, 2022 at 10:49 pm in reply to: Studio Prime
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I got a 404 error on that link

  • Doug McLean

    Member
    April 21, 2022 at 1:06 pm in reply to: Studio Prime
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    yep

  • Doug McLean

    Member
    April 4, 2022 at 2:04 pm in reply to: Example of Using Bluebeam and Power Query
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    lol, yep.
    Happens to me all the time. Especially in Power Automate.

  • Doug McLean

    Member
    March 31, 2022 at 3:31 pm in reply to: Custom Columns
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    I used an Index column in Power Query instead

Page 27 of 31