Here is a quick and easy way to find the sum of resources or resource units.
HELPFUL RESOURCES, LINKS & TRANSCRIPT INFORMATION BELOW: (click on ‘Show More’) ____________________________________________
SmRes calculates the total resource usage for a specified resource within the specified lines.

Syntax:
SmResUnit(x:y,”z”) – Where x and y are the start and end points of the lines to be referenced and z is the resource to be referenced.

Example:
SmRes(1:30, “Truck”) will return the total resource usage for “Truck” in lines 1 through 30 and enter the value into the Quantity column.

SmResUnit calculates the total resource usage for a specific resource unit.

Syntax:
SmResUnit(x:y,”z”) – Where x and y are the start and end points of the lines to be referenced and z is the resource unit to be referenced.

Example:
SmResUnit(1:30, “mhr”) will calculate the total mhrs used on lines 1 through 30 and enter the value into the Quantity column.
____________________________________________

Click the links below to access useful Knowledge Base articles, start a free trial, download the Product Selector, explore our website, or access helpful links at our support hub.

► Cost Estimate Formula List: [ Ссылка ]

Start your free 30-day trial: [ Ссылка ]

► Explore our Homepage and website: [ Ссылка ]
► Support Hub and Product Selector download: [ Ссылка ]
► Knowledge Base: [ Ссылка ]
► Find us on Facebook: [ Ссылка ]
► On LinkedIn: [ Ссылка ]

We’d love to hear from you!

Call us:
24/7 Support: +61 7 3481 9626
Consulting and sales: +61 7 3481 9676
Training: +61 7 3481 9686

Email us:
support(at symbol)pronamics.com.au (replace text with @ symbol)
____________________________________________
TRANSCRIPT

There is a cost estimate formula, which allows you to refer to the usage of a particular resource, or particular resource unit in a formula. These are the SmRes and SmResUnit formulas. Let’s see some examples.

SmRes returns the sum of a resource. First enter the range of the lines you wish to retrieve the resource usage from, then the name of the resource in double inverted commas. Note that the resource name is case sensitive. See the result of this formula is in the total units of the basic labour resource on the referred to lines. Like other formulas that refer to a line, or range of lines, you can see the lines highlighted in red.

SmResUnit returns the sum of a particular unit of a resource and is set up in a very similar way. Instead of entering the name of a resource, simply enter the unit you wish to refer to. This shows us the total usage of resources with a unit of MHR.

Keep in mind that these formulas will include the usage of base resources used within group resources. You can use these formulas as a part of a larger formula also.

For more information including a complete list of formulas, check out our knowledge base in the link down below.

свернуть