[Vince]

I think I may have come across something like this in the past – it was something to do with already having referred to the column in another formula i.e. you can’t refer to the same custom column twice. Well I think that was the issue – it was quite a while ago when I tried to use the formulas in Revu!

[Vince]

I had this problem when I started looking at roofing timbers @Troy. Although, Revu has the cos and tan functions available for use in formulas, I couldn’t find a way to get these to work.

I think that is when I first looked at power query – sorry!

My set up is now quite simple – measure the length of the valley rafter on plan and assign two angles – one for the pitch of the roof and another for the angle away from the main rafters.

Export the markup list to a csv and then let Excel do the rest.

[Vince]

Have you got an example of what you are looking at Doug?

[Vince]

I know if you use the Date column this is updated every time you adjust a markup. So if you filter by this then your adjustments will be the item that you’re working on to the top of the list. Are you saying you are managing to change the order in a different way to this as well?

[Vince]

I’m off to a meeting this morning but am hoping I’ll be back in time to catch you!

[Vince]

Nowhere nearly as interesting as yours @David Cutler but I had an issue with Gas DPC’s membranes a few years ago.

Basically, our bricklayers were having to put some rather expensive DPC’s (£180 for a 60 foot long by 2 foot wide roll) around the perimeter of nearly 500 houses that we were building.

The company that we were working for didn’t want to pay for the manufacturers to make pre-shaped coners and intersections so, our guys were having to cut and tape everything on-site.

The problem was getting the most out of the materials whilst ensuring everything was lapped properly.

So, in my office, I got out the paper and scissors and started a bit of origami. Once I’d perfected all of the shapes I went out to my garage where I had a couple of 8’x4’x1/4″ sheets of ply and proceeded to make about 10 full size templates which the bricklayers could lay over the DPC and then cut away the shapes.

[Vince]

I’m not sure about the other software @David Cutler but I did a 3-day course a couple of weeks ago looking at a 3D cut & fill package – very interesting!

[Vince]

Have you got a screenshot of what you are doing in your example @David Cutler ?

[Vince]

Is there any reason for all the manipulation being done in Revu if the pricing is being done in Excel?

[Vince]

Wow that’s a lot of columns between you guys! My largest set up is for measuring sewers and has about 30 columns. My setup for measuring Brickwork and Scaffolding is 17 columns wide of which only 3 are custom columns for allocating the works to different stages e.g. 1st lift, 2nd lift, etc..

[Vince]

If I’ve understood you correctly this maybe a possible long-winded way to create your arc and other information.

Draw a few ‘template boxes’ then create your arcs. Flatten these template markups. Use dynamic fill to markup the area creating the boundary dimension – polylength or perimeter. Split your boundary at the point your need then delete any unwanted segments.

Not very user friendly though!

[Vince]

A very simply If function would solve a lot of issues!

[Vince]

I like the idea of Sets @Doug but have given up trying to use them over here. Maybe other users are just experiencing the same issues as I am?

[Vince]

That’s great news Doug!

[Vince]

It was Trimble Business Center @David Cutler . It will be more for making adjustments to cut & fill measures that have been by others already e.g. changes in construction types, topsoil depths, etc..