Bruce Kieffer Posted September 24, 2021 Share Posted September 24, 2021 I found the new Median formula, what are the other new formulas? Quote Link to comment

rDesign Posted September 24, 2021 Share Posted September 24, 2021 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 2 Quote Link to comment

Vectorworks, Inc Employee Vlado Posted September 24, 2021 Vectorworks, Inc Employee Share Posted September 24, 2021 @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 1 Quote Link to comment

Kevin C Posted September 29, 2021 Share Posted September 29, 2021 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. Quote Link to comment

rDesign Posted September 29, 2021 Share Posted September 29, 2021 (edited) 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 1 Quote Link to comment

Tobias Kern Posted September 30, 2021 Share Posted September 30, 2021 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 1 Quote Link to comment

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.