contents.gifindex.gifprev1.gifnext1.gif

Working with Lists

DecisionPro's list processing and matrix math abilities are ideal for performing statistical analyses because they make it easy to manage large amounts of data. Tree nodes can contain literally thousands of data points. Whether a node contains a single value or a large set of data, you always reference the node in the same manner. For example, if you want to add 10 to the value in a node named Data, you can use a simple formula like the following:

dph00180.gif

If you want to add 10 to every element in a database named Data, you can use exactly the same formula:

dph00181.gif

Similarly, you can perform statistical calculations and apply functions to data sets by referencing the data as a single entity.

dph00182.gif

dph00183.gif

dph00184.gif

dph00185.gif

Using list-processing abilities in this manner makes it unnecessary to replicate nodes as you would with a spreadsheet. Having only one occurrence of each node makes your models less likely to contain errors that go unnoticed. Moreover, changes are easier to make, models are easier to understand, and models will automatically adapt when the sizes of your data sets change.

For more information about constructing and using lists, refer to Lists and Matrices in the Modeling Language Basics chapter, page 60.

  Budgeting and Forecasting  |  Strategic Planning  |  Decision Support System
Decision Tree Software  |  Monte Carlo Simulations  |  Risk Analysis Software
Portfolio Analysis  |  Expert System  |  Website Surveys

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2008 Vanguard Software Corporation
Forecasting & Planning Solutions
Home Products Solutions Services Customers Partners Company
Vanguard
Applying science to business management
Vanguard
Print this page   Email this page to a friend