Next:
List of Figures
Up:
NExS 1.4 User's Guide
Previous:
NExS 1.4 User's Guide
Contents
List of Figures
List of Tables
1 Introducing NExS
1.1 Overview
1.1.1 Computational Functions
1.1.2 Real-Time Data Transfer
1.1.3 Spreadsheet Output Formats
1.2 Using NExS
1.3 Major Features of NExS
1.3.1 Accessing Spreadsheets
1.3.2 Manipulating the Spreadsheet
1.3.3 Interacting with Other Applications
1.3.4 Functions and Tools
1.3.5 Defining the Appearance of the Spreadsheet and Display
1.3.6 NExS Calculations and Functions
1.3.7 Creating Graphs and Print Files
1.4 About this Manual
1.4.1 Manual Organization
2 NExS Basics
2.1 Using the Mouse and Keyboard
2.1.1 Using the Mouse
2.1.2 Using the Keyboard
2.2 Starting a NExS Session
2.3 NExS Display
2.3.1 Main Menu Bar
2.3.2 Using NExS Menus
2.3.3 Dialog Boxes
Check Button
Option Button
Slider Bar
Data Entry Line or Box
OK and Apply
Cancel
Help
2.3.4 Edit Line
2.3.5 Tool Bar
2.3.6 Spreadsheet Data Area
Column Select Buttons
Row Select Buttons
``Select All'' Button
Cells
Cell Range
Multiple Views
Scroll Bars
Message Line
2.3.7 Window Frame
Current Window
Window Sizing
Iconifying
Moving a Window
2.4 File Selection Dialog
2.5 Spreadsheet Data
2.6 How NExS Handles Errors
2.6.1 Calculation Errors
2.6.2 Syntax Errors
2.6.3 Operational Errors
2.7 How to Get Help
2.7.1 Error Messages
2.7.2 Using On-Line Help
2.8 Ending a NExS Session
3 Accessing Spreadsheets
3.1 Building a New Spreadsheet
3.2 Loading an Existing Spreadsheet
3.2.1 The File Filter
3.2.2 Loading a Spreadsheet in a Different Format
3.3 Saving the Spreadsheet
3.4 Naming the Spreadsheet
3.5 Copying, Moving, Renaming, or Deleting Spreadsheets
3.6 Loading Multiple Sheets At Once
4 Entering Data
4.1 Input Mode and Edit Mode
4.1.1 Input Mode
4.1.2 Edit Mode
4.2 Valid Entries
4.3 Entering Text
4.3.1 Treating Numeric Entries as Text
4.3.2 Repeating Characters
4.3.3 Entering Text Wider than One Cell
Text Wrapping
4.4 Entering Special Characters
4.5 Entering Numeric Values
4.5.1 Entering Numeric Values Wider than the Cell
4.5.2 Changing the Numeric Format
4.6 Entering Dates and Times
4.6.1 Using Date Functions to Enter Dates
4.7 Entering Formulas
4.7.1 Built-in Functions
4.8 Entering Graphs
4.9 Cell Protection
5 Manipulating the Spreadsheet
5.1 Moving Around the Spreadsheet
5.1.1 Moving with the Keyboard
5.1.2 Moving with the Mouse
5.1.3 Moving with the Scroll Bars
5.1.4 Moving with the Go To Function
5.1.5 Moving with the Find Tool
Find Next
Find Previous
Target Criteria
How NExS Evaluates Target Criteria
5.2 Creating Multiple Views
5.3 Correcting Mistakes
5.4 Importing Data from Other Programs
5.5 Setting and Clearing View Titles
5.6 Edit Menu
5.7 Selecting Cells and Ranges
5.7.1 Selecting Ranges Using the Mouse
5.7.2 Selecting Ranges Using the Select Operations
5.7.3 Selecting Ranges Using the Keyboard
5.8 Deselecting Cells and Ranges
5.9 Reselecting a Range of Cells
5.10 Specifying Cells and Ranges in Dialog Boxes
5.11 Named Ranges
5.12 Copying Data
5.12.1 Copying with the Mouse
5.12.2 Using the Copy Menu
5.13 Copying Formulas
5.14 Copying Values
5.15 Tailoring Copy Options
5.16 Moving Data
5.16.1 Effects of Moving Cells
5.17 Copying Data from one Spreadsheet to Another
5.18 Removing Data
5.18.1 Clearing Cells
5.18.2 Deleting Rows and Columns
5.18.3 Starting with a New Sheet
6 Calculations
6.1 How NExS Calculates
6.1.1 Mode of Recalculation
6.1.2 Method of Recalculation
Foreground
As Needed
6.1.3 Iterative Calculations
6.1.4 Constraint Checking
6.1.5 Precision
6.2 NExS Formulas
6.2.1 Formula Syntax
6.2.2 Formula Values
6.2.3 Formula Operators
6.2.4 Referencing Other Cells in Formulas
6.2.5 Cell Referencing in NExS
Relative Reference
Absolute Reference
Current Cell Reference
6.2.6 Constraint Expressions
6.2.7 Explicit Dependency
6.3 Changing Calculation Options
6.3.1 Setting Recalculation Method
6.3.2 Controlling Automatic Recalculation
Disabling Automatic Recalculation
Manual Recalculation
6.3.3 Enabling Constraint Checking
6.3.4 Setting Iteration Limits
6.4 Highlighting Special Calculated Results
7 Built-in Functions
7.1 Mathematical Functions
7.2 Statistical Functions
7.3 Conditional Statistical Functions
7.4 String Functions
7.5 Logic Functions
7.6 Digital Logic Functions
7.7 Financial Functions
7.8 Date and Time Functions
7.9 Miscellaneous Functions
7.10 Embedded Tools
7.11 Quick-Reference Guide to Built-in Functions
7.11.1 Mathematical Functions
7.11.2 Statistical Functions
7.11.3 Conditional Statistical Functions
7.11.4 String Functions
7.11.5 Logic Functions
7.11.6 Digital Logic Functions
7.11.7 Financial Functions
7.11.8 Date and Time Functions
7.11.9 Miscellaneous Functions
7.11.10 Embedded Tools
7.12 Using NExS Built-in Functions
7.12.1 Arguments
7.12.2 Using Operators with Functions
7.13 Computed Cell References
8 Defining the Appearance of the Spreadsheet
8.1 Spreadsheet Appearance
8.1.1 Start-up Defaults
8.1.2 Sheet Defaults
8.1.3 Cell Defaults
8.1.4 Individual Cell Attributes
8.1.5 Highlight Options
8.1.6 Row and Column Specifications
8.1.7 View Titles
8.2 Default Spreadsheet Options
8.2.1 Changing Cell Defaults
8.2.2 Changing Sheet Defaults
8.3 Changing Cell Format
8.4 Changing Decimal Places
8.5 Changing Font Characteristics
8.6 Underlining Cell Contents
8.7 Aligning Cell Contents
8.8 Wrapping Text Within Cell Boundary
8.9 Changing Cell Colors
8.10 Highlight Options
8.11 Currency Style Options
8.12 Row and Column Specifications
8.12.1 Changing Column Width
Using Menus
Best Fit Column Width
Dragging the Column Border
Truncation Alert
8.12.2 Changing Row Height
Using Menus
Best Fit Row Height
Dragging the Row Border
8.12.3 Inserting Rows and Columns
8.12.4 Deleting Rows and Columns
8.13 Creating View Titles
8.13.1 Column View Titles
8.13.2 Row View Titles
8.13.3 Row and Column View Title
8.13.4 Unlocking View Titles
9 Shortcuts and Tools
9.1 Keyboard Accelerators and Mnemonics
9.1.1 Keyboard Accelerators
9.1.2 Mnemonics
9.2 NExS Tools
9.3 Goal Seek
9.4 Sort
9.5 Extract
10 Interacting with Other Applications
10.1 Importing Data into an NExS Spreadsheet
10.1.1 Loading WKS and WK1 Spreadsheets
10.1.2 Loading XLS Spreadsheets
10.1.3 Importing Data Using the Import Cells Operation
10.1.4 Importing Data Using the Paste Operation
10.1.5 Importing Data from Files
10.1.6 Setting Import/Export Options
10.1.7 Importing Text Files
10.1.8 Importing TSV and CSV text files
10.2 Exporting Data from NExS to other Programs
10.2.1 Exporting Data in WKS and WK1 Formats
10.2.2 Exporting Data in NExS Format
Exporting Data using the Export Cells Operation
10.2.3 Exporting Data in Text Format
10.2.4 Exporting Data in TSV or CSV Format
10.2.5 Exporting Data in LateX Tabular Format
10.2.6 Exporting Data as an HTML Table
10.3 Connecting NExS to the Outside World
10.3.1 How Connections Work
10.3.2 Accepting and Refusing Connections
11 Printing the Spreadsheet
11.1 Printing in PostScript Format
11.1.1 PostScript Fonts and NExS
Font Family
Font Style
Font Size
Proportional Spacing
11.2 Printing in ASCII Text Format
11.3 Defining the Appearance of the Output
11.4 Changing Page Layout Options
11.4.1 Changing the Page Size
11.4.2 Changing the Orientation
11.4.3 Changing the Margins
11.4.4 Centering the Output on the Page
11.4.5 Overriding Automatic Page Breaks
Fit To Page
Shrink/Expand
11.4.6 Setting Explicit Page Breaks
11.4.7 Expanding Graph to Page Size
11.4.8 Specifying Row and Column Titles
11.4.9 Enabling Headers and Footers
11.4.10 Enabling Column and Row Borders
11.4.11 Printing Black on White Only
11.4.12 Suppressing Grid Lines
11.5 Defining Printers and Other Output Mechanisms
11.6 Changing Printer Options
11.6.1 Selecting the Type of Output
11.6.2 Changing the Print Destination
11.6.3 Changing Horizontal and Vertical Pitch for Text
11.6.4 What Gets Printed
Default Print Range
Print Range Specification
Explicit Selection
11.6.5 Selecting a Printer
11.7 Printing your Spreadsheet
11.8 Modifying Start-up Defaults
12 Graphs
12.1 Creating a Graph
12.1.1 New Graph Options...
12.1.2 X-Y Data Organization
12.1.3 X-Y-Z Data Organization
12.1.4 Redefining Graph Data Sets
12.2 Graph Editor
12.2.1 File Menu
12.2.2 Redraw
12.2.3 Save
12.2.4 Save As...
12.2.5 Duplicate
12.2.6 Print
12.2.7 Print As...
12.2.8 Cancel
12.2.9 Edit Menu
Data Sets...
12.2.10 Rotate...
12.2.11 Options Menu
General...
X Axis..., Y Axis..., Aux. Y Axis, and Z Axis...
12.3 Using Existing Graphs
12.3.1 Modifying a Graph
12.3.2 Viewing a Graph
12.4 Placing a Graph in the Sheet
12.5 Deleting a Graph
12.6 Types of Graphs
12.6.1 Line and Scatter Graphs
12.6.2 Bar Graphs
12.6.3 Stacked Line and Bar Graphs
12.6.4 Pie Charts
12.6.5 Surface Graphs
12.6.6 Contour Graphs
12.6.7 Polar Graph
12.6.8 Histograms
12.6.9 Error Graph
12.6.10 Hi Lo Graph
12.6.11 Box Graph
12.6.12 Westinghouse Graph
12.7 Modifying Start-up Defaults
13 Graph Tutorial
13.1 Making a Line Graph with a Single Data Set
13.1.1 Drawing the line graph
13.1.2 Redrawing the Graph
13.1.3 Duplicating the Graph
13.1.4 Naming and Saving the Graphs
13.1.5 Canceling and Recalling the Graph
13.1.6 Deleting the Graph
13.1.7 Printing the Graph
13.1.8 Changing the Appearance of the Graph
13.1.9 Annotating the Graph
13.2 Multiple Data Sets
13.2.1 Drawing the Graph
13.2.2 Examining Data Sets
13.2.3 Adding a Legend
13.3 Making Bar Graphs
13.3.1 Drawing the Graph
13.3.2 Starting a New Sheet
13.3.3 Using Text Labels in Bar Graphs
13.4 Making Stacked Bar Graphs
13.5 Making Histograms
13.5.1 Drawing the Graph
13.5.2 Setting Maximum and Minimum Values
13.5.3 Changing the Number of Bins
13.6 Making Pie Charts
13.6.1 Drawing the Graph
13.6.2 Removing Slices of the Pie
13.7 Making Surface Graphs
13.7.1 Drawing the Graph
13.7.2 Rotating the Graph
13.7.3 Surface Graph Colors and Axes
13.8 Making Contour Graphs
13.8.1 Drawing the Graphs
13.8.2 Changing Coloring and Displaying a Legend
13.9 Making a Polar Graph
13.9.1 Drawing the Graph
13.10 Making an Error Graph
13.10.1 Drawing the Graph
13.11 Making a Hi Lo Graph
13.11.1 Drawing the Graph
13.12 Making a Box Graph
13.12.1 Drawing the Graph
13.13 Making a Westinghouse Graph
13.13.1 Drawing the Westinghouse Graph
A Function Reference
B NExS Resources
B.1 NExS Motif Resources
B.2 NExS Local Resources
B.2.1 Cell Defaults
B.2.2 Sheet Defaults
B.2.3 Page Options
B.2.4 Printer Options
B.2.5 Import Options
B.2.6 Copy Options
B.2.7 Recalc Options
B.2.8 Highlight Options
B.2.9 Currency Options
B.2.10 New Graph Options
B.2.11 NExS Graph Resources
Graph General Options
Graph X Axis Options
Graph Y Axis Options
Graph Z Axis Options
Data Set Options
Miscellaneos Graph Resources
B.2.12 Color Palette
B.2.13 Connections
B.2.14 Accelerator Keys
B.2.15 Miscellaneous Resources
C NExS Error Messages
C.1 Types of Errors
C.1.1 Errors in Functions
C.1.2 Formula Syntax Errors
C.1.3 Formula Evaluation Errors
C.2 Summary of Error Messages
D Glossary
Index
About this document ...
Next:
List of Figures
Up:
NExS 1.4 User's Guide
Previous:
NExS 1.4 User's Guide
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999