[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]

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.

[Vince]

Thanks Troy

The problem arises when I am adding say 40 new drawings to an existing set – 35 could be revisions and 5 totally new.

If possible I don’t want to have to go through first and try and work out which are totally new files and add these separately.

Think I must be missing something here!

Thanks

[Vince]

I have adjusted everything as much as possible but could still do with being able to adjust even more – just being fussy I guess! 😆