[Vince]

At the moment I think that’s described as ‘the blind leading the blind’!

[Vince]

There is also supposed to be another method in Excel using the ‘Find and Replace’ function.

Apparently in the find box you press ctrl + j the. In the replace box you put a space.

I’ve managed to get this to work a couple of times but most of the time I get an error message.

I’m not sure if there is a similar function in Word?

[Vince]

If you paste into Excel you can then use the ‘Textjoin’ function to create a single line then delete the original text e.g. if you have copied & pasted from Bluebeam and you have text in cells A1 to A9 then use

=TEXTJOIN(” “,,A1:A9)

[Vince]

All tips gratefully received @dhwalkellc !👍

[Vince]

I’ve been look at creating grids for something else then came up with this….

Create your 2’x2′ template grid in a new document covering the biggest area that you’ll need – cover an A1 piece of paper if needed. Use individual Polylines – this should only take a few minutes.

If you use group to make to copy & paste when drawing your template then make sure everything is ungrouped when you finish.

Then to use: –

1. Copy the whole template page into the document you are working on.

2. Go to the area you are wanting to measure and use “Spaces” and draw around the area that you are looking at.

3. Copy the space and paste it onto your grid instead of trying to put the grid onto your shape.

4. Move the space around to get the best fit on your grid.

5. Go to your mark-ups list and sort by spaces and then select the space that you are working on.

That should be it – 2′ long lengths that are fully captured in the space will be totalled in the mark-up list. This should be the only item within that space so the mark-up list will give you the total length of all the 2’s.

No need for cutting, stretching or deleting of the grid. You can of course make adjustments to the shape of the Space to include any additional 2′ lengths to your measures or you can move the whole shape slightly to see what difference that makes.

Still not 100% accurate but should hopefully get you near enough.

Alternatively, you can go for a slightly more ‘destructive’ route. You will need to know the total length of all the 2′ segments in your grid to start with for this one.

1. Copy the whole template page into the document you are working on.

2. Either use an area mark-up or spaces to copy the shape of the area that you want to measure.

3. Paste the shape onto your grid.

4. Use the lasso tool to trace around your shape – this will select any of the grid line that even partly fall with your area.

5. Delete the selected lines.

6. Deducted the resulting total length of gridlines from your original total to obtain the total length deleted.

This method obviously doesn’t allow for any manipulation or fine tuning though.

😃

[Vince]

Actually, on the 2nd version, don’t delete the lines!

Just rename the subject and change the attributes – maybe make the lines thicker and a different colour so they are easily identifiable.

This way you can then make adjustments if you want to.

To get the total of the lines just sort the mark-up table for whatever you have called the selected lines.

[Vince]

Thanks @Troy! Where do you then add any new drawings – in the original location or in Studio?

[Vince]

😂

[Vince]

Not learning much at the moment David – I’ve found several YouTube videos on Studio but none of them seem to run through this process! Think it is going to be a continuing case of trial & error – all error at the moment though unfortunately! 😂

[Vince]

Try =SUBSTITUTE(A1,CHAR(10), ” “)

[Vince]

Hi @Matt. Glad you found the video helpful!

One bit of advice – when setting up your grid start off by using the ‘sketch to scale’ and copy a few of these across to set up the basic grid. You can then draw your ‘perimeter’ lines over these. This way you can make sure your grid spacings are exact. From there you can copy & paste the perimeter lines to fill out the rest of the page.

[Vince]

😂

[Vince]

@troy-degroot can the batch link be used to edit multiple links in one go? I read something about being able to edit destinations but couldn’t quite follow it tbh! 😂

[Vince]

Unfortunately, it depends on the configuration e.g. if you use a simple example of just four blocks in square and rectangular configurations formulas don’t appear to work. Once you get into much larger and irregular shapes then the discrepancies between formula results and the actual lengths grows.

[Vince]

That’s a great workaround @David – thank you! 👏

I will contact Bluebeam about why the layers are lost when combining drawings once I’ve remembered the procedure for doing this! 😆