Exporting Data to other programs

  • Exporting Data to other programs

     Vince updated 1 week, 4 days ago 6 Members · 27 Posts
  • Doug McLean

    Member
    March 10, 2021 at 8:00 pm
    Points: 1,740
    Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

    I recently completed the major task of setting up Revu to be able to export my markup data to a program called Takeoff. Very daunting to say the least.
    Let’s chat about ways to do this. Tell us about the way you export data.

  • Troy DeGroot

    Organizer
    March 10, 2021 at 8:51 pm
    Points: 6,853
    Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

    I’d be interested to learn what others are doing also. I have built out custom columns to get a proper CSV file export, Quantity Link of course works best for some cases. I have also established a workflow where the CSV export was then converted to a TXT file to be imported into estimating software. Millwork has a lot of different specifics to it, I’m interested to see what you’ve created.

    • rob gibson

      Member
      October 6, 2021 at 7:41 am
      Points: 460
      Rank: UC2 Brainery Newbie UC2 Brainery Newbie Belt Rank

      Hi Guys,

      as a quantity surveyor, i find that the available options and way BB exports the CSV data is not ideal for

      what we call the standard method of measurement ….. mainly that the total is at the top of the stack of markups

      i have played around with filters etc

      but so far have found it easier to use a macro to format the data to something more suitable

      heres an example of what i mean……

      watch from about 5.20……..

      interested in any further opinion/suggestion

      • David Cutler

        Member
        October 6, 2021 at 1:16 pm
        Points: 4,470
        Rank: UC2 Brainery Orange Belt III UC2 Brainery Orange Belt III

        Your macro setup is great Rob! I perform my takeoff in a very similar fashion, and then reduce my data in a .CSV export. I perform the same sort of data reduction in Excel, but I go through the steps every time.

        Looks like I need to learn about macros!

        Thank you for sharing.

        Dave

        • Vince

          Member
          October 7, 2021 at 12:50 am
          Points: 1,525
          Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

          Macros are very good but Power Query takes things to a whole new level!

        • Doug McLean

          Member
          October 7, 2021 at 5:08 pm
          Points: 1,740
          Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

          Completely agree with Vince.
          Macros can do a lot, but can be tricky to write properly.
          While Power Query can be a bit tricky to learn, once its done, its fully repeatable.

          • Vince

            Member
            October 8, 2021 at 12:46 am
            Points: 1,525
            Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

            Although I think I may have just overloaded Power Query with something as it is taking way too long to refresh!

            • Doug McLean

              Member
              October 9, 2021 at 11:37 am
              Points: 1,740
              Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

              You might just need to apply the right filters.

              Could be a lot of things though.

            • Vince

              Member
              October 9, 2021 at 11:54 am
              Points: 1,525
              Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

              By the looks of it I have just overloaded it with too many table merges and appends. So it is back to writing some old fashioned formulas for some of the spreadsheet and some more basic Power Query stuff for the rest.

            • David Cutler

              Member
              October 11, 2021 at 7:00 am
              Points: 4,470
              Rank: UC2 Brainery Orange Belt III UC2 Brainery Orange Belt III

              After getting a glimpse of your spreadsheet I could see how you could overload Power Query @vince !

            • Vince

              Member
              October 11, 2021 at 12:19 pm
              Points: 1,525
              Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

              Hi David.

              I have another spreadsheet specifically for brickwork & scaffolding take-offs – I will try to work out how to post an example on here. No Bluebeam used in the actual measuring but it is extremely fast and still just as accurate.

  • Troy DeGroot

    Organizer
    March 10, 2021 at 8:54 pm
    Points: 6,853
    Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

    One thing that is really important when exporting data is to make sure in the Output Setting to turn off the Replies from being exported. That extra line item can really screw things up!

  • Troy DeGroot

    Organizer
    March 12, 2021 at 3:59 am
    Points: 6,853
    Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

    That sounds awesome David. It fun to have a vision for how it could work and then see it actually work!

  • Doug McLean

    Member
    March 12, 2021 at 7:40 pm
    Points: 1,740
    Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

    David,

    Have you tried using Power Query to do your data washing?

  • David Cutler

    Member
    March 12, 2021 at 9:35 pm
    Points: 4,470
    Rank: UC2 Brainery Orange Belt III UC2 Brainery Orange Belt III

    I’m not familiar with “Power Query” Doug.  Is that an Excel function or another program?  I did investigate Pivot Tables a bit but didn’t get too far with it.  At this point I’m using the “Subtotal” option in the “Outline” tools in Excel.  It’s not perfect as I need to add some formulas in every time to get my item numbers, descriptions and units of measure where I need them, but it keeps me from having to re-key everything.

    I’m not positive but I think my manager still writes everything down on a yellow pad, adds it up with a calculator and then keys the quantities into B2W so I’m light years ahead of him.  Need to make some time to show him some of the new tricks…

    • Doug McLean

      Member
      March 17, 2021 at 12:49 pm
      Points: 1,740
      Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

      Power Query is a function within Excel. If you have O365 you’ll find it under the Data tab. Get and Transform.
      Power Query is a way to ‘wash’ your data in ways that Excel Formula’s can’t do. Its also REALLY good when you have to repeat various steps as new data becomes available.
      I would recommend watching a few YouTube videos on the subject first before trying it.

      • David Cutler

        Member
        March 19, 2021 at 8:36 am
        Points: 4,470
        Rank: UC2 Brainery Orange Belt III UC2 Brainery Orange Belt III

        Thank you for the tip Doug. I watched a quick intro video on the feature. Going to have to explore this further…

        • Brett Ruppel

          Member
          August 16, 2021 at 10:31 am
          Points: 510
          Rank: UC2 Brainery White Belt UC2 Brainery White Belt Rank

          We are using Power Query to scrub bulk B2W Track data into a better report for weekly reviews of job status. Just started doing this, so still perfecting it, but happy to show you what we are doing.

          • Troy DeGroot

            Organizer
            August 16, 2021 at 11:43 am
            Points: 6,853
            Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

            I’d love to hear more Brett, thanks for being in the group!

    • Vince

      Member
      August 29, 2021 at 12:19 pm
      Points: 1,525
      Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

      Hi David. Power Query is a great tool but you can also just use a standard table in Excel from which a pivot table is generated. Once the table is set you can just copy any new data from the csv file output by Bluebeam into the table then hit refresh to update your pivot table.

      I am using this sort of thing all of the time now and the amount of time saved is incredible.

  • Doug McLean

    Member
    August 20, 2021 at 4:42 pm
    Points: 1,740
    Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

    For those of us in the Finishing Trades, Power Query can work better than QL because invariably GC’s want things broken down by room or item even.
    QL is great, but setting it up by Space is time consuming. Its next to impossible to set that up on a Template.
    I have one re-usable workbook that transforms the data to the way I need it based on a BatchConfig file. It also has two macros on it that break the output table into Tabs as per the Spaces column and then saves those tabs as individual csv files which I import into my Estimating Software.

    Its pretty slick.

  • Troy DeGroot

    Organizer
    August 23, 2021 at 3:01 pm
    Points: 6,853
    Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

    I think the trick is to reverse engineer it. Figure out exactly what the import needs to look like. Then build custom columns in Revu to match both the data and the order of the columns. Some columns can have default values, some will have choice menus. After that, you build your tools as detailed as you want to be using the custom data. for instance, you might have the same tool with different manufacturers, so you make 2 tools with different colors and set the default for the manufacturer (or material type or whatever). Hope this makes sense.

    • David Cutler

      Member
      August 24, 2021 at 7:23 am
      Points: 4,470
      Rank: UC2 Brainery Orange Belt III UC2 Brainery Orange Belt III

      I think I’d take it a step further Troy and say that you need to start with how you need to present the information to the client at the end of the process as this drives how you enter the data into the estimating software. Having an item for 10,000 lf of quarter round doesn’t do you any good if your client wants to know how much quarter round is in on each floor.

      Spaces are an interesting topic. I’ve experimented with them some, but haven’t had the right project to fully develop my knowledge of how to use them yet. I wonder if we will ever see a routine in Revu that would auto establish spaces…

      • Troy DeGroot

        Organizer
        August 24, 2021 at 10:01 am
        Points: 6,853
        Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

        That would be nice in Revu, but highly unlikely based on simple lines and text. Revu would never know how to distinguish what boundaries define a space or not. I wouldn’t put it past them to figure it out though.
        I know when you create “Rooms” in Revit, those convert to Spaces when printing to a pdf. (depending on license and settings).

      • Doug McLean

        Member
        August 27, 2021 at 5:17 pm
        Points: 1,740
        Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

        Auto creating Spaces would be amazing.
        I thought I heard that one can from Revit though. The Spaces transfer over

  • Vince

    Member
    August 29, 2021 at 12:13 pm
    Points: 1,525
    Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

    Hi Doug. Looks like I’ve found this topic a bit late in the day!

    I export to Excel where I use a variety of different methods to make my data more usable. Various different formula set-ups, sorting & splitting into with macros and also power query.

    I am also currently doing a power query course which, although I’m only half way through, I can highly recommend.

    What it does mean though is that I can have a standard profiles set up in Bluebeam for various different types of work – drainage, foundations, external works, etc. which can then all be easily exported to a csv and then imported directly into Excel.

    • Doug McLean

      Member
      October 7, 2021 at 5:10 pm
      Points: 1,740
      Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

      Its great isn’t it?

      I learned most of mine by watching ExcelisFun on YouTube, as well as a couple other Excel people.

      Once you get it written, just record a refresh and attach to a button. Even easier.

Viewing 1 - 9 of 9 replies

Original Post
0 of 0 posts June 2018
Now