Examples Of Some Formulas Intro This will give you some examples of formulas that can be used.
Steps Have a "Job" "Job" open o pen Go into "Advanced Properties" on a item you want the formula on. Will create the current date when the item was [!Date]
created. Will create the current time when the item was
[!Time]
created.
[\Job\Name]
Will give you the Job's Name Name Will get the parent items property name.
[..\PropertyName]
Example: [..\Qty] will give you the parent item's [Qty] property. Will give you the [Name] property of the parent of
[..\..\Name]
the parent item item.. Will get the parent's property with the same
[..]
property name. [..\..] Works as well if you need the grandparent's grandparen t's same same property name. Gives you the parent items Takeoff property Units. So you can specify the parent item !Units of ('PropertyName') Example [..\!Units('Takeoff')] will give you SQ FT
[..\!Units('Takeoff')]
if the parent item is a Area. If the parent item is a Linear then the result would would be FT. For Labels Labe ls must must be [..\..\! Units('Takeoff')] . They are childrens of sections, which do not have Units('Takeoff') specified.
Gives you the path to the folder the item is is [!FolderLocation]
located in.
Will add more later!
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
[! ExePath]
Gives you the path of the planswift.exe file.
[\Settings\User]
Gives you the Planswift User Name Gives you a sum of all sub item or children items under that parent item like [!sum(Price Total)] will
[!Sum(PropertyName)]
give you the sum of all sub items under that item. Good for Assemblies to have sum of that property in () on all sub parts. Will pick a random color each time you create a
[!RandomColor]
new item. Returns a value of 3.1415926535897932385 Example:
Pi
Pi*Sqr([Diameter]/2) This example could be used to find the area of a circle.
Hypot(Number1, Number2)
Will return the Hypotenuse Hypotenuse of a right angle. Returns a number squared. This numeric value to be squared. Example:
Sqr(Number) or X^2
Sqr(2) will return 4 Sqr(4) will return 16 Sqr(5) will return 25 Returns the square root of a number. This is a numeric value value to find square root value of. Example:
Sqrt(Number)
Sqrt(25) will return 5 Sqrt(64) will return 8 Sqrt(144) will return 12 Returns e (the base of natural logarithm logarithms) s) raised to a power. This is a numeric value to be raised
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Returns a number of the value rounded to the nearest neare st whole number. If X is exactly halfway halfway between two whole numbers (X.5), the result is always the even number. This method of rounding is often called "Bankers Rounding". Round(Expression)
(Expression) (Ex pression) This is a value to be rounded. Example: 0.5 will round to 0 0.75 will round to 1 1.5 will round to 2
Will round to the nearest half. Example: Round(([Property]*2) Round(([Property]* 2) +0.5)/2
Round(([Takeoff]*2) +0.5)/2 If [Takeoff] was 1.3 result would be 1.5 Returns a number of the value rounded up to the nearest whole whole number. This method of rounding is called "Round Up" (Expression) (Ex pression) This is a value to round up to the
Ceil(Expression)
nearest whole number. Example: Ceil(1.3) will round to 2 Ceil(1.5) will round to 2 Ceil(2.1) will round to 3 Returns a number of the value rounded down to the nearest whole number. This method of rounding is called "Round Down" (Expression) This is a value to round down to the
Floor(Expression)
nearest whole number. Example: Ceil(1.3) will round to 1 Ceil(1.5) will round to 1 Ceil(2.1) will round to 2
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Min(10, 5) will return 5 If ('[Stud Length]' = '8') then result := '8 foot stud 26PC' Else If ('[Stud Lenght]' = '10') then result := '10 foot stud 2610' Else Result := 0
Returns a value based off what what another property prop erty
If ('[PropertyName]'<= '8') then result := 8 Else If ('[PropertyName]'>= '10') then result := 10 Else Result := 0
Is a "If Expression" using < Greater or less then >
is set to. Then at the end If no value is set in [Stud Length] it will result in a 0
signs. Example: if # is 9 if expression will return 10 if # is 6 if expression will return 8 Nested formula. see the How To - Create A
[Property1Name[Property2Name]]
Nested Formulas <--- click to go to the page
Expressions
http://www.planswift.com/kb/entry/285/ <---Link to Expression
