[Vince]

I have started using the new layer configuration setting a lot more for engineering layouts. Declutter a drawing so that when you go out on site you can follow the info a lot more easily e.g. I don’t need to see fence lines / types when I’m interested in the drainage however being able to keep the retaining walls on there is helpful.

[Vince]

Unfortunately with the time differences and the mountain of work I have here I’m not going to have a chance to join any of the sessions.

I look forward to hearing anything from you guys on here about useful tips, etc. over the next couple of weeks though.

[Vince]

As a matter on interest – what type of things are you measuring in this way?

[Vince]

Hi David

Can you shortcut this further by using the ‘Snip & Sketch’ feature on Windows and the just paste the resulting extract straight into Bluebeam?

I’ve used this to copy pictures from websites and put straight into a pdf file in Bluebeam.

[Vince]

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.

[Vince]

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.

[Vince]

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.

[Vince]

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

[Vince]

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

[Vince]

Does “Split All” work for what you need?

[Vince]

Fantastic as always Troy!!!

[Vince]

Thanks Troy – that worked perfectly!

[Vince]

Thanks Troy – I will give that a go later!

[Vince]

Thanks Troy. Unfortunately I am trying to keep the subject titles the same as I need all of the mark-ups together when I export to Excel. Being able to export the colour details is a great start but I could also do with some more detailed info from Bluebeam as well.

I’ve just tried exporting the ID as well in the hope that this column might be generated partly based on the mark-up features but that doesn’t appear to be the case.

I’ll keep looking for another solution. 🧐

[Vince]

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.