Worksheets and phasing

[The Hamma]

I created a worksheet that can display the status of the doors in a drawings.

1. Using the criteria I was able to eliminate the doors that were demolished.
   • =DATABASE(((PON='Door') & ('Door'.'OnSched'=TRUE) & (PHASEREMOVE='')))
2. Using this formula I was able to display the status of each door 
   • =UPPER(PHASESTATUS(Q1))
   • Q1 points to the top right cell with the name of the target phase, in this case "Phase 1 Construction"

 

My question is does anyone know how I would make Q1 a drop down so I can select from the current phases in the drawing rather than having to type it? Having it in Q1 does make it easier than having to retype it in the status formula. 

 

Sample file attached. 

Door Schedule.vwx

[shorter]

If you were to use IFC4 properties (pset_elementcommon.status) and a custom pset, you probably could do it that way quite easily.

Haven't tested the new phasing settings but if it can be mapped to a custom pset via the data manager, then perhaps....

[ashot]

If you are OK typing only 1,2,3... and get populated values for full name of Phases

I would create worksheet with all Phase names for the current project and then in Door Schedule just Reference the external values.

 

Attached is VW 2026 file with copied formula and new worksheet in the same folder as your original Resource place.

 

Door Schedule.vwx

[Tobias Kern]

Hey @The Hamma,

 

A while back, I had a similar thought and expressed it as a suggestion.

 

The idea was that pop-ups from record formats could behave
like drop-down menus in individual cells.

If this is technically possible, it could also work with phasing.

 

by the way:

If you write: =ACTIVEPHASE

in a single cell, you can reference in other functions to that cell.

and the Worksheet show the data relative to the active phase.

It’s certainly not ideal for every use case, but it definitely is for some. 

 

@ashot
Very nice approach!
 

Greetings from Germany
Tobi

[The Hamma]

Thanks @ashot I did not know how to do that and it may come in useful in the future.  

Does not work as I hoped "I think for this I will use @Tobias Kern idea as if I put the worksheet in the annotations of a viewport I can control the value with =ActivePhase until they add some functionality to worksheets or scripts. "

 

This should have worked but when I published the set even though my viewports were set to use the phase if my currently active phase in a design layer is different the worksheets recalculate with the design layer active phase.  

 

 

Edited April 17 by The Hamma

[Pat Stanford]

=ActivePhase is returning what I would expect. The ActivePhase setting of the entire drawing.

 

I don't know of any worksheet functions that return data about where the Worksheet Image is residing.  It would be a nice addition, but currently only Graphical Legends offer that ability, not worksheets.