Please add a Median formula.

[Bruce Kieffer]

My problems would be solved if only Vectorworks had a median function.

[Bruce Kieffer]

OK, I will answer my own wish. It was added to Vectorworks 2022. Thank you, thank you, thank you! It makes so much more sense than the crazy if/then formula I was using.

 

Here's what my if/then formula looked like:

=IF((D3=WIDTH), MIN(HEIGHT, LENGTH), IF((D3=HEIGHT), MIN(WIDTH, LENGTH), MIN(WIDTH, HEIGHT)))

 

Here's the Median formula that produces the same results but much cleaner:

=MEDIAN(HEIGHT, LENGTH, WIDTH)

[Tobias Kern]

Hi Bruce,

 

thnx for reporting this.

 

Are there any other new formulas work worksheets in VW 2022?

 

I unfortunately have to wait until end of October for the localized german version?

 

I want to know, if it is possible with VW 2022:

- can we calculate length, area, volume for the new wrappings around windows?

- can we import text via text-tool into worksheets now?  

- got we more/newer/better specific formulas for the bim tools (walls, slabs, windows, ....)?

- hows it is now: to implement data-tag data to worksheets (better)?

 

Greetings
Tobi

[Bruce Kieffer]

Maybe @Pat Stanford can answer your questions.