Is there a list of new worksheet formulas in Vectorworks 2022?

[Bruce Kieffer]

I found the new Median formula, what are the other new formulas?

[rDesign]

I think you’ll find the list of new 2022 worksheet functions on the following page:

https://developer.vectorworks.net/index.php/WS:Vectorworks_2022_Worksheets

[Vlado]

@Bruce Kieffer all the information is at, this includes full list of functions and Version information (mentioned above)

https://developer.vectorworks.net/index.php/Worksheets

 

 

[Kevin C]

Daft laddie question.

 

I see that there are some additional functions in worksheets - yeahhhh!!.  However, there are still a great number of basic mathematical functions that are available in excel that we do not have (or I can't find them).

 

One such situation is trying to get a worksheet to show the pitch of a stair. I can now get the rise and going (which is a good start), but nowhere can I get the pitch displayed.

 

I wasn't that worried as it is a simple inverse tangent function as there is a simple formula:

 

Going =  X

Rise = Y

 

Pitch = tan^-1(x/y)

 

VW has a "Tan" function - but not an "Inverse Tan" function.  Or am I missing something.  Over 30 years since I did trig at school.

[rDesign]

42 minutes ago, Kevin C said:

VW has a "Tan" function - but not an "Inverse Tan" function.  Or am I missing something.  Over 30 years since I did trig at school.

Over 30 years for me as well, but Vw WS do have an arc tangent function: atan(number)

… which if I recall my Trig class is the same as the inverse tan function?

Edited September 29, 2021 by rDesign

[Tobias Kern]

Hi,

 

yes new formulas are always welcome.

 

Hope Vectorworks can implement the most common formulas from Excel.

 

My first wish: Sumif()

 

But first it would be very welcome, if we can directly use the formulas with

the data-subfields of a list (x.1, x.2, x.3, ..., hope you know what i mean!?) of an WS.

 

Greetings

Tobi