Shaft openings in phases – am I missing something?

Bug reporting is always the big point of Inside the Factory meetings with Autodesk. This year they tried to play on my competitive side, using day by day charts with number of bugs reported by us. Well, I didn’t reach the podium, but I’ll come prepared next time! There are couple of things in Revit that just doesn’t look right, and as of version 2017 – some of those bugs still exist.

I’ve spotted this one working on a partially to-be-demolished basement model, and here’s how to replicate it:

We’ll start with modelling main actors of this tragedy:
Structural slab – Phase created: existing, Phase demolished: none
Shaft opening – Phase created: new construction, Phase demolished: none
And for reference:
Structural column A – Phase Created: existing, Phase Demolished: none
Structural column B – Phase Created: new construction, Phase Demolished: none
Chunk of slab – Phase Created: existing, Phase Demolished: New Construction
In summary:

Now let’s go back to the views. Let’s start with the completed one, i.e how does in look at the end of “New Construction” phase:

Seems about right.

Now let’s go to view highlighting the amount of demolishing taking place (it’s the state “between” existing and new construction):
phase2
Lift opening should be marked in red!

So how does it look in the “Show Complete” (end of “Existing”) phase?
phase3
In my opinion – this is incorrect. The “void” part of shaft openings for some reason ignores the phase in which it was created… and to make it more confusing, detail lines are (correctly) gone. When we look deeper, we see that the model element of “Shaft Opening” category is in fact gone… but it’s effect (void in the slab) is showing preemptively.
As I mentioned before – I might be wrong, maybe I’m missing something – please let me know.
And if anyone is interested with the solution I came up with – that’s what chunk of slab is showing – we’ve started modelling separate ones to simulate the effect of creating a new opening in an existing slab. Detail lines were placed manually.

Import & export Excel spreadsheets with Dynamo

It’s November now and I’m back from vacation. I’m hoping to write a bit more as soon as I deal with accumulated work… but in the meantime: more dynamo scripts!
This one was a collaboration between me and a fellow structural engineer working on structural framing for a one particular high-rise in London. The idea goes like this – in order to automatize steel framing updates (and save countless hours), we need to establish a link between structural software and Revit model. Third-party software solutions were out of question, and long story short – we used Dynamo .xls export/import function to fill in the gap.

Export script:
export
Import script:
import

As you can see, there’s no mind blowing programming work involved, but it was customized to fit this particular task, it works and there are some neat node tricks here and there. As for the future development – I need to figure out a smart way to map beams with those from structural software, now it’s being done by finding a matching “RAM number” (project parameter used just for this task).
Hope you find this useful!