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 ...