# Worksheet Formulas

## Recommended Posts

Looking for some assistance with creating worksheet formulas.

I'm attempting to nest some multipliers in a SUM formula and can't quite find the right way.

My failed attempt:  =SUM(B2..(B3*2)..(B4*3))

Try separating them by commas instead of double periods.

=SUM(B2, (B3*2), (B4*3))

Success.  Thank you!

• 1 year later...

Hi everyone,

I would like to get on with this thread to request some advices on worksheet formulas.

I'm working on a worksheet to centralised information for my space style library. However I can't really figure out the difference between some formulas that seem to return the same information.

For exemple, in order to get the Space Number, it seems that I could indifferently use

='Space'.'11_Number'

=GETSPACENUMFOROBJ

=DSH.'BIM Space'.'Space Number'

>>> would you have a clue on why I should use one formula rather than the other?

Similarly, what it the difference between

='Space'.'11_Gross Perim'

and

='Space'.'Gross Perim'

>>> When should I use one or the other?

Is ='Space'.'11_NameDisplay'

really the same as =GETSPACENAMEFOROBJ

If someone could clarify this for me, it would be really helpful... Thank you very much!

I believe the 11_ parameters are formatted as Strings with units included. That makes them difficult to use in calculations as they are not numbers.

So Space.11_Gross Perim  might return 36,57 sq m.  while Space.Gross Perim would return just 36,57. You could then use a SUM function on the numbers to get the total perimeters.

(I don't have VW open, so I may be backwards on which is string and which is number).

GetSpaceNumForObj is relatively new. I THINK it was added in VW2021, but it may have been in VW2020. I think it was added to make using the worksheet easier so that the user does not HAVE to understand how the parameter record for the Space object is set up.

I have never seen the DSH format before. Or any type of three level indenting of records and fields, so I can not help on that one.

Hi Pat,

Thank you for coming back to me. Yes indeed, I realized that the 11_ parameter does return a rounded number with units included.

About the other different formats, I wonder if they just go and fetch the same information or if the information is somehow translated (same way 11_ is string vs number other wise)... I have deduced that the DSH format is somehow link to some needs related to IFC and Cobie... but not sure. I'll leave it as it is for now.

## 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.

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×

• KBASE
• #### MARIONETTE

×
• Create New...