[Doug McLean]

I did like the idea of a Power BI dashboard on various projects’ deficiency lists…cool idea.

He showed the data Model, but didn’t explain what it was. He’s showing relationships but not explaining them and how they work.

You can’t just do things like that. It will only serve to frustrate people

[Doug McLean]

I actually do this workflow.

One of the (many) advantages of working in a Set is the ability to export a drawing log. One of the things you’re allowed to export is the File Path, so if you export this to either an Excel .xlxs or .csv file, Excel writes the hyperlink formula for you (showing the relative path).

Then you just have to do a little bit of work to get it into wherever you need it, but its not all that hard.

[Doug McLean]

not really

That being said, we just learned that one of the next things getting overhauled is the SharePoint connector to Revu. I guess we’ll see what happens.

Working on SharePoint is great but it does have a few challenges. You might have to do things a little differently than you’re use to doing them. Otherwise, its a much better option than a VPN for remote work

[Doug McLean]

Power BI is really great for visualizations, so that’s what you should use it for.

I do find it easier than Power Pivot for final reporting too.

[Doug McLean]

Insert your own delimiter… that works.

What I meant earlier was about the import of the door schedule. The data was a mess and I probably should have just fixed it in the csv file. A bunch of the columns were offset and I needed to get them all lined up in the right ones.

Once I had that, the rest took me less than 30 minutes

[Doug McLean]

I don’t want to get that crazy… lol 🤣

[Doug McLean]

It doesn’t really show in section well, but one of those is a panel molding that is about 6′ around each opening.

The LDS church really LOVES this level of finish in their temples. The trick is finding the right installation crew to handle the really high end finish.

[Doug McLean]

fortunately all the ceilings here are at 12′ or better, so the crown goes over the top of everything.
As for the doors in the wainscoting, I made a count tool for the different size doors which I will deduct out of the perimeter.

[Doug McLean]

We can also get multiple takeoffs from the one markup.

In most of these rooms, I can get both the crown and the wainscoting from a single markup. (normally I would also get the base, but it’s all stone).

[Doug McLean]

I did this with the door casings and whatnot.
Unfortunately, it took me longer to format the data than it did to do the math. Learned a whole bunch along the way though.

Next up, the wainscoting and all the trim

[Doug McLean]

I don’t think the problem is Revu, the problem is Excel and the way the HYPERLINK formula has to be written.

[Doug McLean]

Did any of them work?

[Doug McLean]

I don’t believe there is, not from Excel.
This is why you have to break down your drawing package into individual pages. That way each page becomes it’s own file.

[Doug McLean]

Vince has my brain working overtime on this one.
I could so use this on all the crown, wainscoting, door trims…. a lot of things. Save the other markups for casework or other things.
This is a typical elevation. Like I said earlier, there is a good finish schedule (which I could export) and then add a couple of columns too (i.e. crown type). Then I could definitely do some wizardry with PQ on things. Spaces are a must.

Hell, I could even kill two birds with one stone and use Dynamic Fill to do a Space and an Perimeter measurement at the same time

Damn you Vince!!!!… 🤣🤣🤯🤣🤣

[Doug McLean]

That is definitely something to think about and you’ve got my brain working on it.

This job is a HUGE LDS temple and has a lot of repeating parts and good schedules.
We’re also in line to be bidding 4-6 of these a year, so anything we can do to speed up the process would be awesome