Command Overview - Other
| Command |
Description |
|
Age amounts |
|
Execute a series of commands from a worksheet |
|
List the five smallest values on the current selected worksheet range |
|
Perform calculations based upon column values |
|
Compute Chi Square Value for the selected range, show degrees of freedom and critical value at 95% |
|
Clear text from a worksheet |
|
The control facility for handling repetitive command line arguments ("set" command) |
|
Prepare a table of cross tabulations |
|
Extract data meeting specified criteria |
|
Check for Gaps in Numerical Sequences (e.g. check numbers) |
|
Set colors for charts displayed |
|
Identify dates falling on federal holidays |
|
Compare Financial Statements |
|
Load historical commands from registry |
|
Logging facility (text of commands entered, and the time) |
|
Check Validity of Credit Card Numbers using the LUHN-10 algorithm |
|
List the sum of counts and amounts for zero, positive and negative values within the current selected range |
|
Load worksheet using database query |
|
Test for round numbers |
|
Save commands from WorkSheet to the Registry |
|
Set a command line argument (such as a file name or column name) |
|
Specify a worksheet range to be processed (for batch processing) |
|
Show current settings |
|
List the five largest values within the current selected range |
|
Chart data points from a series |
|
Trend analysis of amounts over time, using "best fit" linear regression |
|
Remove specification of a worksheet range to be processed (for batch processing) |
|
Display a count of each week day for the selected range |
|