Home : Products : Aspen : Using the Formula Builder
Q10700 - HOWTO: Using the Formula Builder

Using the Formula Builder in Aspen


The formula builder allows you to create a Test in which the reported result for that Test is based on calculations from results of other tests in the system.  You will first need to identify the TestID that needs a calculated result.  Then you need to identify the other Tests that are used in the calculation.  After all Tests have been selected you will need to associate a variable with each Test used in the Calculation, when assigning variables don’t use the letter E.  This is a reserved letter and is used in VBA to signify Exponential.  Now you are ready to enter a formula using the Test variables and known calc factors.



  • Log(x)   - Used for Natural logarithms – x being a number
  • Log(x)/2.303  - Used for Base 10 logarithms – x being a number.  MS Access has only one built in log function and that is “Log” which is the natural log of a number.  If you need to use the base 10 log of a number you will have to convert the Natural Log.
Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?


Tell us why you rated the content this way. (optional)
Approved Comments...
No user comments available for this article.
Created on 2/4/2008 10:59 AM.
Last Modified on 2/4/2008 10:59 AM.
Last Modified by No Author Name Available!.
Article has been viewed 4694 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article