[Vince]

Hi Charles. I come across this issue quite frequently and thought I’d reported it a while ago along with a couple of other glitches. I’ll check and, if not, will report it as a bug later.

[Vince]

Unfortunately, I have no answer to your question and instead just a question of my own.

Is anyone else using Dropbox to store their profiles? I just got a new laptop and want to keep my old one for going out on site. So, I’ve just saved everything to a Dropbox folder which both laptops can access.

All seems to be working okay but I was wondering if there are any issues with this sort of setup that I should be aware of?

[Vince]

Hi Rob. I’m not 100% following what you are doing but happy to have a chat tomorrow if you are about.

[Vince]

Looks interesting @dsperg !

[Vince]

It appears like you are trying to use more than just the summary measure and subject in Excel. In this case the best thing to do is to not use Quantity Link and instead export your entire Markup List to a csv file and then import that into your Excel spreadsheet. This way you can use all of the data.

In Excel, set yourself up a Table for pasting the information from the CSV file and then have all of your other sheets set up ready to use this information. I’ve posted on here about the different levels of information you can get from the exact same Markups – this also has a section on how using Quantity Link can have issues.

Once you get into Excel, you can use a feature called Power Query to automate some of the process.

[Vince]

Unfortunately, I’ve not really tried using it for anything much more than the usual Doug. So, my most ‘unusual’ is using the column associated with the colour of the text to make my valuation sheet in Excel work with dates being associated to the colours.

[Vince]

That looks really helpful @dwane! I have a couple of companies that I am talking to at the moment with say a dozen users who would probably benefit from this – getting it to work even with your clear instructions might still be a challenge though! 🤣

[Vince]

Hi @Doug. Don’t worry, you didn’t miss my reply – I spoke to Rob on the phone!

🤣

[Vince]

I agree MIchael. I know how to ‘measure’ in Revu but how a team would share the same profile, etc. is all new to me so, if people can share the way they do things then this is great. Especially, seeing as Bluebeam don’t appear to offer an easily workable facility for this!

[Vince]

How do you make sure that your teams are all using the same up to date profiles? Do you just rely on them downloading updated profiles as & when they are published?

[Vince]

You won’t regret it!

I would suggest playing around with it a bit first before you decide on exactly what you think you want to get out of it. Hopefully, you fill find that one measurement in Revu combined with Excel may replace several markups that you previously used.

‘Door Type 1’ in Revu can have the following information in a table in Excel: – size & type door, details for hinges, lock type, handle type, door lining details, architrave details, finish to the door, etc, etc, etc..

The idea (from my point of view) is to keep Revu fairly simple so ‘Door Type 1’ never needs to change. The details in Excel are where you make changes, add new, items, etc.. For example, change the type & number of hinges to be used then hit refresh. Within a second or two all of your output information will be updated.

[Vince]

I think we’re all guilty of doing things like that! 🤣

[Vince]

You really don’t need the Power Automate part.

If you update something in Revu then just export the markup list to the csv file.

Then with Power Query you can set it up to find the csv file so, all you have to do is press refresh and you’re done.

So this is all done in a couple of seconds – literally.

[Vince]

I’ve never used Power Automate. If you use Power Query, then this can pull in the information from a CSV file which means if you export from Revu you don’t even have to open the CSV file to get everything to work.

Power Query will also let you do various manipulations, etc. with the info from the Markup List.

[Vince]

I’m wondering what I saw now David and Nic – or should I say what I think I saw!!!