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

Great practice Don – got to love the offset lines! 😀

[Vince]

I have an issue with reappearing layers too Roye. But mine reappear if I undo a linear markup – areas are fine though.

I’ve reported this only to be told that Bluebeam can’t recreate the issue and so I need to uninstall then reinstall Revu – I haven’t done this yet.

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

[Vince]

I don’t have the imperial measurements on my computer here, but I thought that you could just do a custom number format in excel similar to when you do dates and times e.g. dd mmm yyyy. I’m sure I saw an example of someone doing this with feet and inches in which case you shouldn’t need a formula.

[Vince]

Hi Jeremy. When you first create a custom scale, you should also have the option to add it as a preset. If you have already created the scale, go to a sheet using that scale and then click on the scale and then, once again, in the dialogue box that pops up you should have the option to add it as a preset.

[Vince]

If you create a grid template, you can centre this to the centre of the room and you can also rotate it as necessary.

[Vince]

This formula can be used to work out the revised area: –
(ceiling(Width / 4) * 4) * (ceiling(Height / 2) * 2)

However, this relies on the markup being the correct orientation and also being a rectangle or square.

If the room is an irregular shape, then I can only see using a template grid as being the way to work out exactly how many whole tiles are required.

Edit: – You could also add “/8” at the end of the above formula to get the number of whole tiles..