SMS:Data Calculator: Difference between revisions
(20 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
<noinclude> | |||
{{SMS_at_a_glance_data_calculator|Heading===At a glance==}} | {{SMS_at_a_glance_data_calculator|Heading===At a glance==}} | ||
</noinclude> | |||
The Data Calculator can be used to perform mathematical operations with datasets to create new datasets. The Data Calculator is accessed by selecting the ''' | The ''Data Calculator'' can be used to perform mathematical operations with datasets to create new datasets. The ''Data Calculator'' is part of the ''Dataset Toolbox'' dialog and is accessed by selecting the '''Dataset Toolbox''' command from the ''Data'' or ''Edit'' menu. The components of the ''Data Calculator'' are as follows: | ||
=== Expression Field === | === Expression Field === | ||
The most important part of the Data Calculator is the Expression field. This is where the mathematical expression is entered. The expression should be formulated using the same rules that are used in formulating equations in a spreadsheet. Parentheses should be used to clearly indicate the preferred order of evaluation. There is no limit on the length of the expression. The operators in the expression should be limited to the operators shown in the middle of the Data Calculator. The operands in the expression should consist of user-defined constants (e.g., 3.14159), or datasets. | The most important part of the ''Data Calculator'' is the ''Expression'' field. This is where the mathematical expression is entered. The expression should be formulated using the same rules that are used in formulating equations in a spreadsheet. Parentheses should be used to clearly indicate the preferred order of evaluation. There is no limit on the length of the expression. The operators in the expression should be limited to the operators shown in the middle of the Data Calculator. The operands in the expression should consist of user-defined constants (e.g., 3.14159), or datasets. | ||
=== List of Datasets === | === List of Datasets === | ||
All of the datasets associated with the active object (TIN, Grid, Mesh, or Scatter Point Set) are listed at the top of the Data Calculator. If a transient | All of the datasets associated with the active object (TIN, Grid, Mesh, or Scatter Point Set) are listed at the top of the Data Calculator. If a transient dataset is highlighted, the time steps are listed on the right side of the Data Calculator. When a dataset is used in an expression, the name of the dataset should NOT be used. Rather, the letter associated with the dataset should be used. For example, if a dataset is listed as "b. head1", the dataset is referenced in the expression simply as "b" | ||
When a transient dataset is used in an expression, either a single time step or the entire sequence of time steps may be used. For example, the expression "abs(d:100)" creates a single (steady state) | When a transient dataset is used in an expression, either a single time step or the entire sequence of time steps may be used. For example, the expression "abs(d:100)" creates a single (steady state) dataset representing the absolute value of the dataset at time = 100.0. However, the expression "abs(d:all)" creates a transient dataset representing the absolute value of each of the time steps in the original dataset. | ||
=== Result Name === | === Result Name === | ||
When an expression is evaluated, a new | When an expression is evaluated, a new dataset is created and the name of the new dataset is designated in the ''Result'' field. | ||
=== Operators === | === Operators === | ||
The allowable operators are listed in the middle of the dialog. Selecting one of the operator buttons adds the selected operator to the end of the expression. However, the operators can also be typed directly in the expression field. The function of each of the operators is as follows: | The allowable operators are listed in the middle of the dialog. Selecting one of the operator buttons adds the selected operator to the end of the expression. However, the operators can also be typed directly in the expression field. The function of each of the operators is as follows: | ||
{| | {| class="wikitable" | ||
!width=" | !width="100"|Operator | ||
!width=" | !width="200"|Function | ||
|- | |- | ||
|<center> | |<center> + </center> | ||
|Add | |||
|- | |- | ||
|<center> | |<center> - </center> | ||
|Subtract | |||
|- | |- | ||
|<center> | |<center> * </center> | ||
|Multiply | |||
|- | |- | ||
|<center> | |<center> / </center> | ||
|Divide | |||
|- | |- | ||
|<center> | |<center> ( </center> | ||
|Left Parenthesis | |||
|- | |- | ||
|<center> | |<center> ) </center> | ||
|Right /Parenthesis | |||
|- | |- | ||
|<center> | |<center> log(x) </center> | ||
|The base 10 logarithm of a dataset | |||
|- | |- | ||
|<center> | |<center> ln(x) </center> | ||
|The natural logarithm of a dataset | |||
|- | |- | ||
|<center> | |<center> x^a </center> | ||
|(x) raised to the (a) power. (x) and | |||
(a) can be any mixture of constants and datasets | |||
|- | |- | ||
|<center> | |<center> abs(x) </center> | ||
|The absolute value of a dataset | |||
|- | |- | ||
|<center> | |<center> sqrt(x) </center> | ||
|The square root of a dataset | |||
|- | |- | ||
|<center> | |<center> ave(x,y) </center> | ||
|The average of two datasets | |||
|- | |- | ||
|<center> | |<center> min(x,y) </center> | ||
|The minimum of two datasets | |||
|- | |- | ||
|<center> | |<center> max(x,y) </center> | ||
|The maximum of two datasets | |||
|- | |- | ||
|<center> | |<center> trunc(x,a,b) </center> | ||
|Truncates a dataset (x) so that all | |||
values are >= a and <= b | |||
|- | |- | ||
|<center> | |<center> 1/(x) </center> | ||
|The inverse of (x) - Only available in SMS | |||
|} | |} | ||
====Operating | ====Operating With Transient Datasets==== | ||
Each argument in the operators listed in the table above may be: | Each argument in the operators listed in the table above may be: | ||
* A steady state (1 time step) dataset | * A steady state (1 time step) dataset | ||
* A specified time step of a transient dataset (i.e. x:#). In this case the # represents the index of the time step as specified in the time step window. | * A specified time step of a transient dataset (i.e., x:#). In this case the # represents the index of the time step as specified in the time step window. | ||
* A transient time step (i.e. x:all). These operations are only valid if all arguments have matching time step values. In this case, the result will be a new transient dataset with identical time values as the arguments. | * A transient time step (i.e., x:all). These operations are only valid if all arguments have matching time step values. In this case, the result will be a new transient dataset with identical time values as the arguments. | ||
The data calculator supports an alternate format for computing attributes of a transient dataset. This alternate format applies to three of the operators. These operators compute a single time step (steady state) dataset representing the spatially varied attribute operating on all the time steps. | The data calculator supports an alternate format for computing attributes of a transient dataset. This alternate format applies to three of the operators. These operators compute a single time step (steady state) dataset representing the spatially varied attribute operating on all the time steps. | ||
{| | {| class="wikitable" | ||
!width="200"|Operator | !width="200"|Operator | ||
!width="500"|Function | !width="500"|Function | ||
|- | |- | ||
|<center> | |<center> ave(x:all) </center>||The average at each location of all time steps in the dataset | ||
|- | |- | ||
|<center> | |<center> min(x:all) </center>||The minimum at each location of all time steps in the dataset | ||
|- | |- | ||
|<center> | |<center> max(x:all) </center>||The maximum at each location of all time steps in the dataset | ||
|} | |} | ||
=== Compute Button === | === Compute Button === | ||
Once an expression is formulated and a name for the resulting dataset has been specified, the expression can be evaluated by selecting the Compute button. At this point, the dataset is created and the name of the new dataset should appear in the list of datasets. | Once an expression is formulated and a name for the resulting dataset has been specified, the expression can be evaluated by selecting the '''Compute''' button. At this point, the dataset is created and the name of the new dataset should appear in the list of datasets. | ||
==Related Links== | ==Related Links== | ||
* [[SMS:Datasets|Datasets (SMS)]] | |||
* [[SMS:Dataset Toolbox|Dataset Toolbox (SMS)]] | |||
<!--* [[Dataset_Calculator_Tool|Dataset Calculator Tool]]--> | |||
* [[Data Calculator|GMS/WMS Data Calculator]] | |||
* [[Data Calculator Examples]] | |||
{{Navbox SMS}} | |||
[[Category:Datasets|D]] | |||
[[Category:SMS General Information|D]] | |||
[[Category:SMS Dataset Dialogs]] |
Latest revision as of 23:14, 5 August 2024
At a glance
- Performs mathematical calculations on scalar datasets
- Calculations can include any number of scalar datasets and user supplied numbers
- Useful for computing derived values such as Froude numbers
- Useful for comparing scalar datasets
The Data Calculator can be used to perform mathematical operations with datasets to create new datasets. The Data Calculator is part of the Dataset Toolbox dialog and is accessed by selecting the Dataset Toolbox command from the Data or Edit menu. The components of the Data Calculator are as follows:
Expression Field
The most important part of the Data Calculator is the Expression field. This is where the mathematical expression is entered. The expression should be formulated using the same rules that are used in formulating equations in a spreadsheet. Parentheses should be used to clearly indicate the preferred order of evaluation. There is no limit on the length of the expression. The operators in the expression should be limited to the operators shown in the middle of the Data Calculator. The operands in the expression should consist of user-defined constants (e.g., 3.14159), or datasets.
List of Datasets
All of the datasets associated with the active object (TIN, Grid, Mesh, or Scatter Point Set) are listed at the top of the Data Calculator. If a transient dataset is highlighted, the time steps are listed on the right side of the Data Calculator. When a dataset is used in an expression, the name of the dataset should NOT be used. Rather, the letter associated with the dataset should be used. For example, if a dataset is listed as "b. head1", the dataset is referenced in the expression simply as "b"
When a transient dataset is used in an expression, either a single time step or the entire sequence of time steps may be used. For example, the expression "abs(d:100)" creates a single (steady state) dataset representing the absolute value of the dataset at time = 100.0. However, the expression "abs(d:all)" creates a transient dataset representing the absolute value of each of the time steps in the original dataset.
Result Name
When an expression is evaluated, a new dataset is created and the name of the new dataset is designated in the Result field.
Operators
The allowable operators are listed in the middle of the dialog. Selecting one of the operator buttons adds the selected operator to the end of the expression. However, the operators can also be typed directly in the expression field. The function of each of the operators is as follows:
Operator | Function |
---|---|
Add | |
Subtract | |
Multiply | |
Divide | |
Left Parenthesis | |
Right /Parenthesis | |
The base 10 logarithm of a dataset | |
The natural logarithm of a dataset | |
(x) raised to the (a) power. (x) and
(a) can be any mixture of constants and datasets | |
The absolute value of a dataset | |
The square root of a dataset | |
The average of two datasets | |
The minimum of two datasets | |
The maximum of two datasets | |
Truncates a dataset (x) so that all
values are >= a and <= b | |
The inverse of (x) - Only available in SMS |
Operating With Transient Datasets
Each argument in the operators listed in the table above may be:
- A steady state (1 time step) dataset
- A specified time step of a transient dataset (i.e., x:#). In this case the # represents the index of the time step as specified in the time step window.
- A transient time step (i.e., x:all). These operations are only valid if all arguments have matching time step values. In this case, the result will be a new transient dataset with identical time values as the arguments.
The data calculator supports an alternate format for computing attributes of a transient dataset. This alternate format applies to three of the operators. These operators compute a single time step (steady state) dataset representing the spatially varied attribute operating on all the time steps.
Operator | Function |
---|---|
The average at each location of all time steps in the dataset | |
The minimum at each location of all time steps in the dataset | |
The maximum at each location of all time steps in the dataset |
Compute Button
Once an expression is formulated and a name for the resulting dataset has been specified, the expression can be evaluated by selecting the Compute button. At this point, the dataset is created and the name of the new dataset should appear in the list of datasets.
Related Links
SMS – Surface-water Modeling System | ||
---|---|---|
Modules: | 1D Grid • Cartesian Grid • Curvilinear Grid • GIS • Map • Mesh • Particle • Quadtree • Raster • Scatter • UGrid | |
General Models: | 3D Structure • FVCOM • Generic • PTM | |
Coastal Models: | ADCIRC • BOUSS-2D • CGWAVE • CMS-Flow • CMS-Wave • GenCade • STWAVE • WAM | |
Riverine/Estuarine Models: | AdH • HEC-RAS • HYDRO AS-2D • RMA2 • RMA4 • SRH-2D • TUFLOW • TUFLOW FV | |
Aquaveo • SMS Tutorials • SMS Workflows |